package com.mc2.docapp.disabilityassessmenttool;

import android.app.Activity;
import android.os.Bundle;
import android.os.Environment;
import android.view.View;
import android.widget.Button;
import android.widget.TextView;

import com.mc2.docapp.disabilityassessmenttool.utils.MailerObject;
import com.mc2.docapp.disabilityassessmenttool.utils.SendMailTLS;
import com.mc2.docapp.disabilityassessmenttool.wrapper_computation.FinalComputationDTO;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.Date;

import static com.mc2.docapp.disabilityassessmenttool.AdditionalInfo.additionalInfoDTO;
import static com.mc2.docapp.disabilityassessmenttool.NewPatient.pateint;

public class FinalCalculation extends Activity {

    public FinalComputationDTO finalDto;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_final_calculation);
        finalDto = NewPatient.finalDto;
        TextView finalDisab = (TextView) findViewById(R.id.calculatedDisability);
        TextView withResp = (TextView) findViewById(R.id.withRespectValue);
        TextView permOrTemp = (TextView) findViewById(R.id.permOrTemp);
        TextView revRequired = (TextView) findViewById(R.id.revRequired);


        Button saveNnextButton = (Button) findViewById(R.id.saveAndNext);
        saveNnextButton.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                double finalCal = NewPatient.finalDto.calTotalDisablity(NewPatient.finalDto);
                NewPatient.finalDto.setTotalDisability(finalCal);
                finalDisab.setText(String.valueOf(finalCal));
                String wrtBody = "wrt";
                if (AdditionalInfo.activityFLow.size() > 1) {
                    withResp.setText("Whole Body");
                    wrtBody = wrtBody + "Whole Body";
                } else {
                    for (Object value : AdditionalInfo.activityFLow.keySet()) {
                        withResp.setText(value.toString());
                        wrtBody = wrtBody + value.toString();
                    }
                }

                if (additionalInfoDTO.isDeformityTreatable()) {
                    permOrTemp.setText("TEMP");
                } else {
                    permOrTemp.setText("PERMANENT");
                }

                revRequired.setText(additionalInfoDTO.getRevaluationRequired());

                try {
                    String uq = "Report_" + pateint.getPatient_record_no() + "_" + pateint.getDob() + "_" + pateint.getPatient_phone() + ".xls";
                    uq = uq.replaceAll("/", "-").replaceAll(" ","_");
                    File ff = new File(Environment.getExternalStorageDirectory() + File.separator + uq);
                    ff.createNewFile();
                    FileOutputStream fos = new FileOutputStream(ff);
                    saveExcelFile(fos);
                    fos.close();
                    {
                        try {
                            SendMailTLS.getMailer().sendMail(new MailerObject(pateint.getDocmail(), "DISABILITY ASSESEMENT REPORT", ff.getAbsolutePath()), true);
                        } catch (Exception e) {
                            e.printStackTrace();
                        }
                    }
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        });
    }

    private double calByFormula(double a, double b) {
        if (a < b) {
            a = a + b;
            b = a - b;
            a = a - b;
        }
        double c = a + (((90 - a) * b) / 90.0);
        return c;
    }

    public void saveExcelFile(FileOutputStream outputStream) throws IOException {

        Workbook wb = new HSSFWorkbook();

        CellStyle cs = wb.createCellStyle();
        cs.setFillForegroundColor(HSSFColor.LIME.index);


        //
       /* SampleExcelDTO sampleExcelDTO = new SampleExcelDTO(1,1,"c","d",new Date());
        mapDtoToExcel(SampleExcelDTO.class);*/
        //


        Sheet sheet1 = wb.createSheet("work");

        Row row = sheet1.createRow(0);
        Cell c = row.createCell(0);
        c.setCellValue("DISABILITY ASSESSMENT AS PER MINISTRY OF SOCIAL JUSTICE AND EMPOWERMENT GUIDELINES 2018");
        c.setCellStyle(cs);


        // PATIENT DETAILS
        final Row row1 = sheet1.createRow(1);
        Cell cell1 = row1.createCell(0);
        cell1.setCellValue("(Data Entry into Dark grey Cells only)");


        final Row row2 = sheet1.createRow(2);
        cell1 = row2.createCell(0);
        cell1.setCellValue("Institute / Medical Board");
        cell1 = row2.createCell(1);
        cell1.setCellValue("DUMMY Shashwat Hospital");


        final Row row3 = sheet1.createRow(3);
        cell1 = row3.createCell(0);
        cell1.setCellValue("Examination / Record No.");
        cell1 = row3.createCell(1);
        cell1.setCellValue("DUMMY 9890382866");

        final Row row4 = sheet1.createRow(4);
        cell1 = row4.createCell(0);
        cell1.setCellValue("Date of Assessment");
        cell1 = row4.createCell(1);
        cell1.setCellValue("DUMMY 22 Jan 2018");

        final Row row5 = sheet1.createRow(5);
        cell1 = row5.createCell(0);
        cell1.setCellValue("Patient Name");
        cell1 = row5.createCell(1);
        cell1.setCellValue("DUMMY Rajnikant ");

        final Row row6 = sheet1.createRow(6);
        cell1 = row6.createCell(0);
        cell1.setCellValue("Age");
        cell1 = row6.createCell(1);
        cell1.setCellValue("DUMMY 28");

        final Row row7 = sheet1.createRow(7);
        cell1 = row7.createCell(0);
        cell1.setCellValue("Sex");
        cell1 = row7.createCell(1);
        cell1.setCellValue("MALE");

        final Row row8 = sheet1.createRow(8);
        cell1 = row8.createCell(0);
        cell1.setCellValue("Diagnosis");
        cell1 = row8.createCell(1);
        cell1.setCellValue("DIALCIES");


        final Row row9 = sheet1.createRow(9);
        cell1 = row9.createCell(0);
        cell1.setCellValue("Measurements Taken By");
        cell1 = row9.createCell(1);
        cell1.setCellValue("DUMMY Doctor and Patient");

        //BLANK ROW
        final Row row10 = sheet1.createRow(10);

        //UPPER LIMB COMPONENT

        final Row row11 = sheet1.createRow(11);
        cell1 = row11.createCell(0);
        cell1.setCellValue("I.UPPER LIMB COMPONENT");
        cell1 = row11.createCell(1);
        cell1.setCellValue("FUNCTION");
        cell1 = row11.createCell(2);
        cell1.setCellValue("Normal value (/Max.Value)");
        cell1 = row11.createCell(3);
        cell1.setCellValue("Actual Reading on Right Side");
        cell1 = row11.createCell(4);
        cell1.setCellValue("Actual Reading on Left Side");
        cell1 = row11.createCell(5);
        cell1.setCellValue("Percentage Loss on Right Side");
        cell1 = row11.createCell(6);
        cell1.setCellValue("Percentage Loss on Left Side");
        cell1 = row11.createCell(7);
        cell1.setCellValue("Mean Loss on Right Side");
        cell1 = row11.createCell(8);
        cell1.setCellValue("Mean Loss on Left Side");
        cell1 = row11.createCell(9);
        cell1.setCellValue("Summation of Right Side");
        cell1 = row11.createCell(10);
        cell1.setCellValue("Summation of Left Side");


        final Row row12 = sheet1.createRow(12);
        cell1 = row12.createCell(0);
        cell1.setCellValue("ARM COMPONENT");

        final Row row13 = sheet1.createRow(13);
        cell1 = row13.createCell(0);
        cell1.setCellValue("ACTIVE ROM (degrees)");

        final Row row14 = sheet1.createRow(14);
        cell1 = row14.createCell(0);
        cell1.setCellValue("SHOULDER");
        cell1 = row14.createCell(1);
        cell1.setCellValue("Flexion - Extension Arc");
        cell1 = row14.createCell(2);
        cell1.setCellValue("220°");
        cell1 = row14.createCell(3);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_shoulder().getFlexion_extension_arc().getActual_right());
        cell1 = row14.createCell(4);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_shoulder().getFlexion_extension_arc().getActual_left());
        cell1 = row14.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_shoulder().getFlexion_extension_arc().getPerc_loss_right());
        cell1 = row14.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_shoulder().getFlexion_extension_arc().getPerc_loss_left());
        cell1 = row14.createCell(7);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_shoulder().getInner_calculations().getMean_loss_right());
        cell1 = row14.createCell(8);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_shoulder().getInner_calculations().getMean_loss_left());
        cell1 = row14.createCell(9);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_shoulder().getInner_calculations().getMean_loss_right() * 0.2);
        cell1 = row14.createCell(10);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_shoulder().getInner_calculations().getMean_loss_left() * 0.2);


        final Row row15 = sheet1.createRow(15);
        cell1 = row15.createCell(0);
        cell1 = row15.createCell(1);
        cell1.setCellValue("Internal - External Rotation Arc°");
        cell1 = row15.createCell(2);
        cell1.setCellValue("180°");
        cell1 = row15.createCell(3);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_shoulder().getInternal_external_rotation_arc().getActual_right());
        cell1 = row15.createCell(4);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_shoulder().getInternal_external_rotation_arc().getActual_left());
        cell1 = row15.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_shoulder().getInternal_external_rotation_arc().getPerc_loss_right());
        cell1 = row15.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_shoulder().getInternal_external_rotation_arc().getPerc_loss_left());


        final Row row16 = sheet1.createRow(16);
        cell1 = row16.createCell(0);
        cell1 = row16.createCell(1);
        cell1.setCellValue("Adduction - Abduction Arc");
        cell1 = row16.createCell(2);
        cell1.setCellValue("180°");
        cell1 = row16.createCell(3);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_shoulder().getAdduction_abduction_arc().getActual_right());
        cell1 = row16.createCell(4);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_shoulder().getAdduction_abduction_arc().getActual_left());
        cell1 = row16.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_shoulder().getAdduction_abduction_arc().getPerc_loss_right());
        cell1 = row16.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_shoulder().getAdduction_abduction_arc().getPerc_loss_left());


        //UPLIMB ELBOW
        final Row row17 = sheet1.createRow(17);
        cell1 = row17.createCell(0);
        cell1.setCellValue("ELBOW");
        cell1 = row17.createCell(1);
        cell1.setCellValue("Flexion - Extension Arc");
        cell1 = row17.createCell(2);
        cell1.setCellValue("150°");
        cell1 = row17.createCell(3);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_elbow().getFlexion_extension_arc().getActual_right());
        cell1 = row17.createCell(4);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_elbow().getFlexion_extension_arc().getActual_left());
        cell1 = row17.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_elbow().getFlexion_extension_arc().getPerc_loss_right());
        cell1 = row17.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_elbow().getFlexion_extension_arc().getPerc_loss_left());
        cell1 = row17.createCell(7);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_elbow().getInner_calculations().getMean_loss_right());
        cell1 = row17.createCell(8);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_elbow().getInner_calculations().getMean_loss_left());
        cell1 = row17.createCell(9);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_elbow().getInner_calculations().getMean_loss_right() * 0.2);
        cell1 = row17.createCell(10);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_elbow().getInner_calculations().getMean_loss_left() * 0.2);

        final Row row18 = sheet1.createRow(18);
        cell1 = row18.createCell(0);
        cell1 = row18.createCell(1);
        cell1.setCellValue("Supination - Pronation Arc");
        cell1 = row18.createCell(2);
        cell1.setCellValue("180°");
        cell1 = row18.createCell(3);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_elbow().getSupination_pronation_arc().getActual_right());
        cell1 = row18.createCell(4);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_elbow().getSupination_pronation_arc().getActual_left());
        cell1 = row18.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_elbow().getSupination_pronation_arc().getPerc_loss_right());
        cell1 = row18.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_elbow().getSupination_pronation_arc().getPerc_loss_left());

        final Row row19 = sheet1.createRow(19);
        cell1 = row19.createCell(0);
        cell1.setCellValue("WRIST");
        cell1 = row19.createCell(1);
        cell1.setCellValue("Flexion - Extension Arc");
        cell1 = row19.createCell(2);
        cell1.setCellValue("160°");
        cell1 = row19.createCell(3);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_wrist().getFlexion_extension_arc().getActual_right());
        cell1 = row19.createCell(4);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_wrist().getFlexion_extension_arc().getActual_left());
        cell1 = row19.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_wrist().getFlexion_extension_arc().getPerc_loss_right());
        cell1 = row19.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_wrist().getFlexion_extension_arc().getPerc_loss_left());
        cell1 = row19.createCell(7);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_wrist().getInner_calculations().getMean_loss_right());
        cell1 = row19.createCell(8);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_wrist().getInner_calculations().getMean_loss_left());
        cell1 = row19.createCell(9);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_wrist().getInner_calculations().getMean_loss_right() * 0.1);
        cell1 = row19.createCell(10);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_wrist().getInner_calculations().getMean_loss_left() * 0.1);

        final Row row20 = sheet1.createRow(20);
        cell1 = row20.createCell(0);
        cell1 = row20.createCell(1);
        cell1.setCellValue("Radial - Ulnar Deviation Arc");
        cell1 = row20.createCell(2);
        cell1.setCellValue("55°");
        cell1 = row20.createCell(3);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_wrist().getRadial_ulnar_deviation_arc().getActual_right());
        cell1 = row20.createCell(4);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_wrist().getRadial_ulnar_deviation_arc().getActual_left());
        cell1 = row20.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_wrist().getRadial_ulnar_deviation_arc().getPerc_loss_right());
        cell1 = row20.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getUlca_wrist().getRadial_ulnar_deviation_arc().getPerc_loss_left());

        //BLANK
        final Row row21 = sheet1.createRow(21);
        cell1 = row21.createCell(9);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().getInnerCalculations().getSummation_right());
        cell1 = row21.createCell(10);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getActive_rom_degrees().
                getInnerCalculations().getSummation_left());

        //MUSCLE POWER
        final Row row22 = sheet1.createRow(22);
        cell1 = row22.createCell(0);
        cell1.setCellValue("MUSCLE POWER (x/5) (x=0 to5)");

        final Row row23 = sheet1.createRow(23);
        cell1 = row23.createCell(0);
        cell1.setCellValue("SHOULDER");
        cell1 = row23.createCell(1);
        cell1.setCellValue("Flexion");
        cell1 = row23.createCell(2);
        cell1.setCellValue("5");
        cell1 = row23.createCell(3);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getFlexion().getActual_right());
        cell1 = row23.createCell(4);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getFlexion().getActual_left());
        cell1 = row23.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getFlexion().getPerc_loss_right());
        cell1 = row23.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getFlexion().getPerc_loss_left());
        cell1 = row23.createCell(7);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getInner_calculations().getMean_loss_right());
        cell1 = row23.createCell(8);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getInner_calculations().getMean_loss_left());
        cell1 = row23.createCell(9);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getInner_calculations().getMean_loss_right() * 0.3);
        cell1 = row23.createCell(10);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getInner_calculations().getMean_loss_left() * 0.3);

        final Row row24 = sheet1.createRow(24);
        cell1 = row24.createCell(0);
        cell1 = row24.createCell(1);
        cell1.setCellValue("Extension");
        cell1 = row24.createCell(2);
        cell1.setCellValue("5");
        cell1 = row24.createCell(3);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getExtension().getActual_right());
        cell1 = row24.createCell(4);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getExtension().getActual_left());
        cell1 = row24.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getExtension().getPerc_loss_right());
        cell1 = row24.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getExtension().getPerc_loss_left());

        final Row row25 = sheet1.createRow(25);
        cell1 = row25.createCell(0);
        cell1 = row25.createCell(1);
        cell1.setCellValue("Internal Rotation");
        cell1 = row25.createCell(2);
        cell1.setCellValue("5");
        cell1 = row25.createCell(3);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getInternal_rotation().getActual_right());
        cell1 = row25.createCell(4);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getInternal_rotation().getActual_left());
        cell1 = row25.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getInternal_rotation().getPerc_loss_right());
        cell1 = row25.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getInternal_rotation().getPerc_loss_left());

        final Row row26 = sheet1.createRow(26);
        cell1 = row26.createCell(0);
        cell1 = row26.createCell(1);
        cell1.setCellValue("External Rotation");
        cell1 = row26.createCell(2);
        cell1.setCellValue("5");
        cell1 = row26.createCell(3);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getExternal_rotation().getActual_right());
        cell1 = row26.createCell(4);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getExternal_rotation().getActual_left());
        cell1 = row26.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getExternal_rotation().getPerc_loss_right());
        cell1 = row26.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getExternal_rotation().getPerc_loss_left());


        final Row row27 = sheet1.createRow(27);
        cell1 = row27.createCell(0);
        cell1 = row27.createCell(1);
        cell1.setCellValue("Adduction");
        cell1 = row27.createCell(2);
        cell1.setCellValue("5");
        cell1 = row27.createCell(3);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getAdduction().getActual_right());
        cell1 = row27.createCell(4);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getAdduction().getActual_left());
        cell1 = row27.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getAdduction().getPerc_loss_right());
        cell1 = row27.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getAdduction().getPerc_loss_left());

        final Row row28 = sheet1.createRow(28);
        cell1 = row28.createCell(0);
        cell1 = row28.createCell(1);
        cell1.setCellValue("Abduction");
        cell1 = row28.createCell(2);
        cell1.setCellValue("5");
        cell1 = row28.createCell(3);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getAbduction().getActual_right());
        cell1 = row28.createCell(4);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getAbduction().getActual_left());
        cell1 = row28.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getAbduction().getPerc_loss_right());
        cell1 = row28.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_shoulder().getAbduction().getPerc_loss_left());


        //MUSCLE ELBOW
        final Row row29 = sheet1.createRow(29);
        cell1 = row29.createCell(0);
        cell1.setCellValue("ELBOW");
        cell1 = row29.createCell(1);
        cell1.setCellValue("Flexion");
        cell1 = row29.createCell(2);
        cell1.setCellValue("5");
        cell1 = row29.createCell(3);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_elbow().getFlexion().getActual_right());
        cell1 = row29.createCell(4);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_elbow().getFlexion().getActual_left());
        cell1 = row29.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_elbow().getFlexion().getPerc_loss_right());
        cell1 = row29.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_elbow().getFlexion().getPerc_loss_left());
        cell1 = row29.createCell(7);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_elbow().getInner_calculations().getMean_loss_right());
        cell1 = row29.createCell(8);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_elbow().getInner_calculations().getMean_loss_left());
        cell1 = row29.createCell(9);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_elbow().getInner_calculations().getMean_loss_right() * 0.3);
        cell1 = row29.createCell(10);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_elbow().getInner_calculations().getMean_loss_left() * 0.3);

        final Row row30 = sheet1.createRow(30);
        cell1 = row30.createCell(0);
        cell1 = row30.createCell(1);
        cell1.setCellValue("Extension");
        cell1 = row30.createCell(2);
        cell1.setCellValue("5");
        cell1 = row30.createCell(3);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_elbow().getExtension().getActual_right());
        cell1 = row30.createCell(4);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_elbow().getExtension().getActual_left());
        cell1 = row30.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_elbow().getExtension().getPerc_loss_right());
        cell1 = row30.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_elbow().getExtension().getPerc_loss_left());

        final Row row31 = sheet1.createRow(31);
        cell1 = row31.createCell(0);
        cell1 = row31.createCell(1);
        cell1.setCellValue("Supination");
        cell1 = row31.createCell(2);
        cell1.setCellValue("5");
        cell1 = row31.createCell(3);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_elbow().getSupination().getActual_right());
        cell1 = row31.createCell(4);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_elbow().getSupination().getActual_left());
        cell1 = row31.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_elbow().getSupination().getPerc_loss_right());
        cell1 = row31.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_elbow().getSupination().getPerc_loss_left());


        final Row row32 = sheet1.createRow(32);
        cell1 = row32.createCell(0);
        cell1 = row32.createCell(1);
        cell1.setCellValue("Pronation");
        cell1 = row32.createCell(2);
        cell1.setCellValue("5");
        cell1 = row32.createCell(3);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_elbow().getPronation().getActual_right());
        cell1 = row32.createCell(4);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_elbow().getPronation().getActual_left());
        cell1 = row32.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_elbow().getPronation().getPerc_loss_right());
        cell1 = row32.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_elbow().getPronation().getPerc_loss_left());


        //MUSCLE WRIST
        final Row row33 = sheet1.createRow(33);
        cell1 = row33.createCell(0);
        cell1.setCellValue("WRIST");
        cell1 = row33.createCell(1);
        cell1.setCellValue("Dorsiflexion");
        cell1 = row33.createCell(2);
        cell1.setCellValue("5");
        cell1 = row33.createCell(3);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_wrist().getDorsiflexion().getActual_right());
        cell1 = row33.createCell(4);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_wrist().getDorsiflexion().getActual_left());
        cell1 = row33.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_wrist().getDorsiflexion().getPerc_loss_right());
        cell1 = row33.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_wrist().getDorsiflexion().getPerc_loss_left());
        cell1 = row33.createCell(7);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_wrist().getInner_calculations().getMean_loss_right());
        cell1 = row33.createCell(8);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_wrist().getInner_calculations().getMean_loss_left());
        cell1 = row33.createCell(9);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_wrist().getInner_calculations().getMean_loss_right() * 0.3);
        cell1 = row33.createCell(10);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_wrist().getInner_calculations().getMean_loss_left() * 0.3);

        final Row row34 = sheet1.createRow(34);
        cell1 = row34.createCell(0);
        cell1 = row34.createCell(1);
        cell1.setCellValue("Palmarflexion");
        cell1 = row34.createCell(2);
        cell1.setCellValue("5");
        cell1 = row34.createCell(3);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_wrist().getPalmarflexion().getActual_right());
        cell1 = row34.createCell(4);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_wrist().getPalmarflexion().getActual_left());
        cell1 = row34.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_wrist().getPalmarflexion().getPerc_loss_right());
        cell1 = row34.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_wrist().getPalmarflexion().getPerc_loss_left());
        cell1 = row34.createCell(7);

        final Row row35 = sheet1.createRow(35);
        cell1 = row35.createCell(0);
        cell1 = row35.createCell(1);
        cell1.setCellValue("Radial Deviation");
        cell1 = row35.createCell(2);
        cell1.setCellValue("5");
        cell1 = row35.createCell(3);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_wrist().getRadial_deviation().getActual_right());
        cell1 = row35.createCell(4);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_wrist().getRadial_deviation().getActual_left());
        cell1 = row35.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_wrist().getRadial_deviation().getPerc_loss_right());
        cell1 = row35.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_wrist().getRadial_deviation().getPerc_loss_left());

        final Row row36 = sheet1.createRow(36);
        cell1 = row36.createCell(0);
        cell1 = row36.createCell(1);
        cell1.setCellValue("Palmar Deviation");
        cell1 = row36.createCell(2);
        cell1.setCellValue("5");
        cell1 = row36.createCell(3);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_wrist().getPalmar_deviation().getActual_right());
        cell1 = row36.createCell(4);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_wrist().getPalmar_deviation().getActual_left());
        cell1 = row36.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_wrist().getPalmar_deviation().getPerc_loss_right());
        cell1 = row36.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getC_ulmp_wrist().getPalmar_deviation().getPerc_loss_left());

        final Row row37 = sheet1.createRow(37);
        cell1 = row37.createCell(9);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().getInnerCalculations().getSummation_right());
        cell1 = row37.createCell(10);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getMuscle_power().
                getInnerCalculations().getSummation_left());

        //CO_ACTIVITIES
        final Row row39 = sheet1.createRow(39);
        cell1 = row39.createCell(0);
        cell1.setCellValue("LOSS IN 10 CO-ORDINATED ACTIVITIES (max. 9% each)");

        final Row row40 = sheet1.createRow(40);
        cell1 = row40.createCell(0);
        cell1 = row40.createCell(1);
        cell1.setCellValue("Overhead Lifting of Object");
        cell1 = row40.createCell(2);
        cell1.setCellValue("0%");
        cell1 = row40.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getLoss_in_10_co_ordinated_activities().
                getOverheadLifting().getPerc_loss_right());
        cell1 = row40.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getLoss_in_10_co_ordinated_activities().
                getOverheadLifting().getPerc_loss_left());
        cell1 = row40.createCell(9);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getLoss_in_10_co_ordinated_activities().
                getInner_calculations().getSummation_right());
        cell1 = row40.createCell(10);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getLoss_in_10_co_ordinated_activities().
                getInner_calculations().getSummation_left());


        final Row row41 = sheet1.createRow(41);
        cell1 = row41.createCell(0);
        cell1 = row41.createCell(1);
        cell1.setCellValue("Touching Nose with Finger");
        cell1 = row41.createCell(2);
        cell1.setCellValue("0%");
        cell1 = row41.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getLoss_in_10_co_ordinated_activities().
                getTouchingNose().getPerc_loss_right());
        cell1 = row41.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getLoss_in_10_co_ordinated_activities().
                getTouchingNose().getPerc_loss_left());

        final Row row42 = sheet1.createRow(42);
        cell1 = row42.createCell(0);
        cell1 = row42.createCell(1);
        cell1.setCellValue("Eating");
        cell1 = row42.createCell(2);
        cell1.setCellValue("0%");
        cell1 = row42.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getLoss_in_10_co_ordinated_activities().
                getEating().getPerc_loss_right());
        cell1 = row42.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getLoss_in_10_co_ordinated_activities().
                getEating().getPerc_loss_left());

        final Row row43 = sheet1.createRow(43);
        cell1 = row43.createCell(0);
        cell1 = row43.createCell(1);
        cell1.setCellValue("Combing");
        cell1 = row43.createCell(2);
        cell1.setCellValue("0%");
        cell1 = row43.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getLoss_in_10_co_ordinated_activities().
                getCombing().getPerc_loss_right());
        cell1 = row43.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getLoss_in_10_co_ordinated_activities().
                getCombing().getPerc_loss_left());

        final Row row44 = sheet1.createRow(44);
        cell1 = row44.createCell(0);
        cell1 = row44.createCell(1);
        cell1.setCellValue("Putting on Shirt");
        cell1 = row44.createCell(2);
        cell1.setCellValue("0%");
        cell1 = row44.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getLoss_in_10_co_ordinated_activities().
                getPuttingShirt().getPerc_loss_right());
        cell1 = row44.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getLoss_in_10_co_ordinated_activities().
                getPuttingShirt().getPerc_loss_left());

        final Row row45 = sheet1.createRow(45);
        cell1 = row45.createCell(0);
        cell1 = row45.createCell(1);
        cell1.setCellValue("Ablution");
        cell1 = row45.createCell(2);
        cell1.setCellValue("0%");
        cell1 = row45.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getLoss_in_10_co_ordinated_activities().
                getAblution().getPerc_loss_right());
        cell1 = row45.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getLoss_in_10_co_ordinated_activities().
                getAblution().getPerc_loss_left());

        final Row row46 = sheet1.createRow(46);
        cell1 = row46.createCell(0);
        cell1 = row46.createCell(1);
        cell1.setCellValue("Drinking from Glass");
        cell1 = row46.createCell(2);
        cell1.setCellValue("0%");
        cell1 = row46.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getLoss_in_10_co_ordinated_activities().
                getDrinkingFromGlass().getPerc_loss_right());
        cell1 = row46.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getLoss_in_10_co_ordinated_activities().
                getDrinkingFromGlass().getPerc_loss_left());

        final Row row47 = sheet1.createRow(47);
        cell1 = row47.createCell(0);
        cell1 = row47.createCell(1);
        cell1.setCellValue("Buttoning");
        cell1 = row47.createCell(2);
        cell1.setCellValue("0%");
        cell1 = row47.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getLoss_in_10_co_ordinated_activities().
                getButtoning().getPerc_loss_right());
        cell1 = row47.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getLoss_in_10_co_ordinated_activities().
                getButtoning().getPerc_loss_left());

        final Row row48 = sheet1.createRow(48);
        cell1 = row48.createCell(0);
        cell1 = row48.createCell(1);
        cell1.setCellValue("Tying Knot");
        cell1 = row48.createCell(2);
        cell1.setCellValue("0%");
        cell1 = row48.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getLoss_in_10_co_ordinated_activities().
                getTyingKnot().getPerc_loss_right());
        cell1 = row48.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getLoss_in_10_co_ordinated_activities().
                getTyingKnot().getPerc_loss_left());

        final Row row49 = sheet1.createRow(49);
        cell1 = row49.createCell(0);
        cell1 = row49.createCell(1);
        cell1.setCellValue("Writing");
        cell1 = row49.createCell(2);
        cell1.setCellValue("0%");
        cell1 = row49.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getLoss_in_10_co_ordinated_activities().
                getWriting().getPerc_loss_right());
        cell1 = row49.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getLoss_in_10_co_ordinated_activities().
                getWriting().getPerc_loss_left());


        final Row row50 = sheet1.createRow(50);
        cell1 = row50.createCell(0);
        cell1.setCellValue("TOTAL ARM COMPONENT (max 90%)");
        cell1 = row50.createCell(1);
        cell1.setCellValue("ROM + POWER + CoOrdinated Activities");
        cell1 = row50.createCell(9);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getTotalArmCommponentRight());
        cell1 = row50.createCell(10);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_arm_component().getTotalArmCommponentLeft());

        //HAND COMPONENT
        final Row row51 = sheet1.createRow(51);
        cell1 = row51.createCell(0);
        cell1.setCellValue("HAND COMPONENT");

        final Row row52 = sheet1.createRow(52);
        cell1 = row52.createCell(0);
        cell1.setCellValue(" LOSS IN HAND FUNCTION (30%) Prehension");

        final Row row53 = sheet1.createRow(53);
        cell1 = row53.createCell(0);
        cell1 = row53.createCell(1);
        cell1.setCellValue("Lateral Pinch (Key Holding)");
        cell1 = row53.createCell(2);
        cell1.setCellValue("5%");
        cell1 = row53.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getLateral_pinch().getActual_right());
        cell1 = row53.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getLateral_pinch().getActual_left());
        cell1 = row53.createCell(9);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getHc_innerCalculations().getSummation_right());
        cell1 = row53.createCell(10);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getHc_innerCalculations().getSummation_left());

        final Row row54 = sheet1.createRow(54);
        cell1 = row54.createCell(0);
        cell1 = row54.createCell(1);
        cell1.setCellValue("Hook Grasp");
        cell1 = row54.createCell(2);
        cell1.setCellValue("5%");
        cell1 = row54.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getHook_grasp().getActual_right());
        cell1 = row54.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getHook_grasp().getActual_left());

        final Row row55 = sheet1.createRow(55);
        cell1 = row55.createCell(0);
        cell1 = row55.createCell(1);
        cell1.setCellValue("Opposition to index finger");
        cell1 = row55.createCell(2);
        cell1.setCellValue("2%");
        cell1 = row55.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getOpposition_to_index_finger().getActual_right());
        cell1 = row55.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getOpposition_to_index_finger().getActual_left());

        final Row row56 = sheet1.createRow(56);
        cell1 = row56.createCell(0);
        cell1 = row56.createCell(1);
        cell1.setCellValue("Opposition to middle finger");
        cell1 = row56.createCell(2);
        cell1.setCellValue("2%");
        cell1 = row56.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getOpposition_to_middle_finger().getActual_right());
        cell1 = row56.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getOpposition_to_middle_finger().getActual_left());


        final Row row57 = sheet1.createRow(57);
        cell1 = row57.createCell(0);
        cell1 = row57.createCell(1);
        cell1.setCellValue("Opposition to ring finger");
        cell1 = row57.createCell(2);
        cell1.setCellValue("2%");
        cell1 = row57.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getOpposition_to_ring_finger().getActual_right());
        cell1 = row57.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getOpposition_to_ring_finger().getActual_left());

        final Row row58 = sheet1.createRow(58);
        cell1 = row58.createCell(0);
        cell1 = row58.createCell(1);
        cell1.setCellValue("Opposition to little finger");
        cell1 = row58.createCell(2);
        cell1.setCellValue("2%");
        cell1 = row58.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getOpposition_to_little_finger().getActual_right());
        cell1 = row58.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getOpposition_to_little_finger().getActual_left());

        final Row row59 = sheet1.createRow(59);
        cell1 = row59.createCell(0);
        cell1 = row59.createCell(1);
        cell1.setCellValue("Cylindrical Grasp (Small 1\")");
        cell1 = row59.createCell(2);
        cell1.setCellValue("3%");
        cell1 = row59.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getCylindrical_grasp_Small_1().getActual_right());
        cell1 = row59.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getCylindrical_grasp_Small_1().getActual_left());

        final Row row60 = sheet1.createRow(60);
        cell1 = row60.createCell(0);
        cell1 = row60.createCell(1);
        cell1.setCellValue("Cylindrical Grasp (Large 4\")");
        cell1 = row60.createCell(2);
        cell1.setCellValue("3%");
        cell1 = row60.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getCylindrical_grasp_Large_4().getActual_right());
        cell1 = row60.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getCylindrical_grasp_Large_4().getActual_left());

        final Row row61 = sheet1.createRow(61);
        cell1 = row61.createCell(0);
        cell1 = row61.createCell(1);
        cell1.setCellValue("Spherical Grasp (Small 1\")");
        cell1 = row61.createCell(2);
        cell1.setCellValue("3%");
        cell1 = row61.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getSpherical_grasp_Small_1().getActual_right());
        cell1 = row61.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getSpherical_grasp_Small_1().getActual_left());


        final Row row62 = sheet1.createRow(62);
        cell1 = row62.createCell(0);
        cell1 = row62.createCell(1);
        cell1.setCellValue("Spherical Grasp (Large 4\")");
        cell1 = row62.createCell(2);
        cell1.setCellValue("3%");
        cell1 = row62.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getSpherical_grasp_Large_4().getActual_right());
        cell1 = row62.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getSpherical_grasp_Large_4().getActual_left());

        final Row row63 = sheet1.createRow(63);
        cell1 = row63.createCell(0);
        cell1.setCellValue("LOSS IN HAND STRENGTH (30%)");
        cell1 = row63.createCell(1);
        cell1.setCellValue("Grip");
        cell1 = row63.createCell(2);
        cell1.setCellValue("20%");
        cell1 = row63.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getGrip().getActual_right());
        cell1 = row63.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getGrip().getActual_left());

        final Row row64 = sheet1.createRow(64);
        cell1 = row64.createCell(0);
        cell1 = row64.createCell(1);
        cell1.setCellValue("Pinch");
        cell1 = row64.createCell(2);
        cell1.setCellValue("10%");
        cell1 = row64.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getPinch().getActual_right());
        cell1 = row64.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getPinch().getActual_left());

        final Row row65 = sheet1.createRow(65);
        cell1 = row65.createCell(0);
        cell1.setCellValue("LOSS OF HAND SENSATION (30%)");
        cell1 = row65.createCell(1);
        cell1.setCellValue("Thumb");
        cell1 = row65.createCell(2);
        cell1.setCellValue("9%");
        cell1 = row65.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getThumb().getActual_right());
        cell1 = row65.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getThumb().getActual_left());

        final Row row66 = sheet1.createRow(66);
        cell1 = row66.createCell(0);
        cell1 = row66.createCell(1);
        cell1.setCellValue("Index Finger");
        cell1 = row66.createCell(2);
        cell1.setCellValue("6%");
        cell1 = row66.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getIndex_finger().getActual_right());
        cell1 = row66.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getIndex_finger().getActual_left());


        final Row row67 = sheet1.createRow(67);
        cell1 = row67.createCell(0);
        cell1 = row67.createCell(1);
        cell1.setCellValue("Middle Finger");
        cell1 = row67.createCell(2);
        cell1.setCellValue("5%");
        cell1 = row67.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getMiddle_finger().getActual_right());
        cell1 = row67.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getMiddle_finger().getActual_left());


        final Row row68 = sheet1.createRow(68);
        cell1 = row68.createCell(0);
        cell1 = row68.createCell(1);
        cell1.setCellValue("Ring Finger");
        cell1 = row68.createCell(2);
        cell1.setCellValue("5%");
        cell1 = row68.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getRing_finger().getActual_right());
        cell1 = row68.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getRing_finger().getActual_left());


        final Row row69 = sheet1.createRow(69);
        cell1 = row69.createCell(0);
        cell1 = row69.createCell(1);
        cell1.setCellValue("Little Finger");
        cell1 = row69.createCell(2);
        cell1.setCellValue("5%");
        cell1 = row69.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getLittle_finger().getActual_right());
        cell1 = row69.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getLittle_finger().getActual_left());

        final Row row70 = sheet1.createRow(70);
        cell1 = row70.createCell(0);
        cell1.setCellValue("TOTAL HAND COMPONENT (max 90%)");
        cell1 = row70.createCell(1);
        cell1.setCellValue("Function + Strength + Sensation");
        cell1 = row70.createCell(2);
        cell1.setCellValue("90%");
        cell1 = row70.createCell(9);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getHc_innerCalculations().getSummation_right());
        cell1 = row70.createCell(10);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_hand_component().getHc_innerCalculations().getSummation_left());

        final Row row71 = sheet1.createRow(71);
        cell1 = row71.createCell(0);
        cell1.setCellValue("ARM + HAND COMPONENT");
        cell1 = row71.createCell(9);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getArmPlushandCompRight());
        cell1 = row71.createCell(10);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getArmPlushandCompRight());

        //ADDITIONAL WEIGHTAGE

        final Row row72 = sheet1.createRow(72);
        cell1 = row72.createCell(0);
        cell1.setCellValue("ADDITIONAL WEIGHTAGE");

        final Row row73 = sheet1.createRow(73);
        cell1 = row73.createCell(0);
        cell1 = row73.createCell(1);
        cell1.setCellValue("Pain (Mild 3% Mod 6% Severe 9%)");
        cell1 = row73.createCell(2);


        final Row row74 = sheet1.createRow(74);
        cell1 = row74.createCell(0);
        cell1 = row74.createCell(1);
        cell1.setCellValue("Affection of Dominant Extremity");
        cell1 = row74.createCell(2);


        final Row row75 = sheet1.createRow(75);
        cell1 = row75.createCell(0);
        cell1 = row75.createCell(1);
        cell1.setCellValue("Deformity (Functional 3% Non Functional 6%)");
        cell1 = row75.createCell(2);


        final Row row76 = sheet1.createRow(76);
        cell1 = row76.createCell(0);
        cell1 = row76.createCell(1);
        cell1.setCellValue("Loss of Sensations (Partial 6% Complete 9%)");
        cell1 = row76.createCell(2);
        cell1 = row76.createCell(5);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_additional_weightage().getAdditionalWgtage().getActual_right());
        cell1 = row76.createCell(6);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_additional_weightage().getAdditionalWgtage().getActual_left());
        cell1 = row76.createCell(9);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_additional_weightage().getAdditionalWgtage().getActual_right());
        cell1 = row76.createCell(10);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getClass_additional_weightage().getAdditionalWgtage().getActual_left());


        final Row row77 = sheet1.createRow(77);
        cell1 = row77.createCell(0);
        cell1 = row77.createCell(1);
        cell1.setCellValue("Complications (Supf 3% Deep 6%)");
        cell1 = row77.createCell(2);

        final Row row78 = sheet1.createRow(78);
        cell1 = row78.createCell(0);
        cell1 = row78.createCell(1);
        cell1.setCellValue("Shortening (1st inch NIL, every inch thereafter 2%)");
        cell1 = row78.createCell(2);
        /*sheet1.addMergedRegion(new CellRangeAddress(73, 78, 2,2));
        row75.createCell(2).setCellValue("Max 10%");*/

        final Row row79 = sheet1.createRow(79);
        cell1 = row79.createCell(0);
        cell1.setCellValue("TOTAL U/L COMPONENT");
        cell1 = row79.createCell(2);
        cell1.setCellValue("100% max");
        cell1 = row79.createCell(9);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getTotalUPLIMBCompRight());
        cell1 = row79.createCell(10);
        cell1.setCellValue(finalDto.getClass_upperLimb_component().getTotalUPLIMBCompLEFT());


        //LOWER LIMB COMPONENT
        final Row row80 = sheet1.createRow(80);
        cell1 = row80.createCell(0);
        cell1.setCellValue("II.LOWER LIMB COMPONENT");

        final Row row81 = sheet1.createRow(81);
        cell1 = row81.createCell(0);
        cell1.setCellValue("LOSS IN MOBILITY COMPONENT");

        final Row row82 = sheet1.createRow(82);
        cell1 = row82.createCell(0);
        cell1.setCellValue("ACTIVE ROM (degrees)");

        //UL HIP
        final Row row83 = sheet1.createRow(83);
        cell1 = row83.createCell(0);
        cell1.setCellValue("HIP");
        cell1 = row83.createCell(1);
        cell1.setCellValue("Flexion - Extension Arc");
        cell1 = row83.createCell(2);
        cell1.setCellValue("140°");
        cell1 = row83.createCell(3);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_hip().
                getFlexion_extension_arc().getActual_right());
        cell1 = row83.createCell(4);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_hip().
                getFlexion_extension_arc().getActual_left());
        cell1 = row83.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_hip().
                getFlexion_extension_arc().getPerc_loss_right());
        cell1 = row83.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_hip().
                getFlexion_extension_arc().getPerc_loss_left());
        cell1 = row83.createCell(7);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_hip().
                getInner_calculations().getMean_loss_right());
        cell1 = row83.createCell(8);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_hip().
                getInner_calculations().getMean_loss_left());
        cell1 = row83.createCell(9);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_hip().
                getInner_calculations().getMean_loss_right() * 0.35);
        cell1 = row83.createCell(10);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_hip().
                getInner_calculations().getMean_loss_left() * 0.35);


        final Row row84 = sheet1.createRow(84);
        cell1 = row84.createCell(0);
        cell1 = row84.createCell(1);
        cell1.setCellValue("Internal - External Rotation Arc");
        cell1 = row84.createCell(2);
        cell1.setCellValue("90°");
        cell1 = row84.createCell(3);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_hip().
                getInternal_external_rotation_arc().getActual_right());
        cell1 = row84.createCell(4);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_hip().
                getInternal_external_rotation_arc().getActual_left());
        cell1 = row84.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_hip().
                getInternal_external_rotation_arc().getPerc_loss_right());
        cell1 = row84.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_hip().
                getInternal_external_rotation_arc().getPerc_loss_left());


        final Row row85 = sheet1.createRow(85);
        cell1 = row85.createCell(0);
        cell1 = row85.createCell(1);
        cell1.setCellValue("Adduction - Abduction Arc");
        cell1 = row85.createCell(2);
        cell1.setCellValue("90°");
        cell1 = row85.createCell(3);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_hip().
                getAdduction_abduction_arc().getActual_right());
        cell1 = row85.createCell(4);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_hip().
                getAdduction_abduction_arc().getActual_left());
        cell1 = row85.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_hip().
                getAdduction_abduction_arc().getPerc_loss_right());
        cell1 = row85.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_hip().
                getAdduction_abduction_arc().getPerc_loss_left());


        //KNEE
        final Row row86 = sheet1.createRow(86);
        cell1 = row86.createCell(0);
        cell1.setCellValue("KNEE");
        cell1 = row86.createCell(1);
        cell1.setCellValue("Flexion - Extension Arc");
        cell1 = row86.createCell(2);
        cell1.setCellValue("125°");
        cell1 = row86.createCell(3);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_knee().
                getFlexion_extension_arc().getActual_right());
        cell1 = row86.createCell(4);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_knee().
                getFlexion_extension_arc().getActual_left());
        cell1 = row86.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_knee().
                getFlexion_extension_arc().getPerc_loss_right());
        cell1 = row86.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_knee().
                getFlexion_extension_arc().getPerc_loss_left());
        cell1 = row86.createCell(7);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_knee().
                getInner_calculations().getMean_loss_right());
        cell1 = row86.createCell(8);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_knee().
                getInner_calculations().getMean_loss_left());
        cell1 = row86.createCell(9);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_knee().
                getInner_calculations().getMean_loss_right() * 0.35);
        cell1 = row86.createCell(10);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_knee().
                getInner_calculations().getMean_loss_left() * 0.35);

        //ANKLE N FOOT
        final Row row87 = sheet1.createRow(87);
        cell1 = row87.createCell(0);
        cell1.setCellValue("ANKLE & FOOT");
        cell1 = row87.createCell(1);
        cell1.setCellValue("Plantar - Dorsiflexion Arc");
        cell1 = row87.createCell(2);
        cell1.setCellValue("70°");
        cell1 = row87.createCell(3);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_ankleFoot().
                getPlantar_dorsiflection_arc().getActual_right());
        cell1 = row87.createCell(4);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_ankleFoot().
                getPlantar_dorsiflection_arc().getActual_left());
        cell1 = row87.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_ankleFoot().
                getPlantar_dorsiflection_arc().getPerc_loss_right());
        cell1 = row87.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_ankleFoot().
                getPlantar_dorsiflection_arc().getPerc_loss_left());
        cell1 = row87.createCell(7);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_ankleFoot().
                getInner_calculations().getMean_loss_right());
        cell1 = row87.createCell(8);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_ankleFoot().
                getInner_calculations().getMean_loss_left());
        cell1 = row87.createCell(9);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_ankleFoot().
                getInner_calculations().getMean_loss_right() * 0.35);
        cell1 = row87.createCell(10);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_ankleFoot().
                getInner_calculations().getMean_loss_left() * 0.35);

        final Row row88 = sheet1.createRow(88);
        cell1 = row88.createCell(0);
        cell1 = row88.createCell(1);
        cell1.setCellValue("Inversion - Eversion");
        cell1 = row88.createCell(2);
        cell1.setCellValue("60°");
        cell1 = row88.createCell(3);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_ankleFoot().
                getInversion_eversion().getActual_right());
        cell1 = row88.createCell(4);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_ankleFoot().
                getInversion_eversion().getActual_left());
        cell1 = row88.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_ankleFoot().
                getInversion_eversion().getPerc_loss_right());
        cell1 = row88.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getC_llca_ankleFoot().
                getInversion_eversion().getPerc_loss_left());

        final Row row89 = sheet1.createRow(89);
        cell1 = row89.createCell(9);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getInnerCalculations().getSummation_right());
        cell1 = row89.createCell(9);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getInnerCalculations().getSummation_left());

        //MUSCLE POWER
        final Row row90 = sheet1.createRow(90);
        cell1 = row90.createCell(0);
        cell1.setCellValue("MUSCLE POWER (x/5) (x=0 to5)");

        //HIP
        final Row row91 = sheet1.createRow(91);
        cell1 = row91.createCell(0);
        cell1.setCellValue("HIP");
        cell1 = row91.createCell(1);
        cell1.setCellValue("Flexion");
        cell1 = row91.createCell(2);
        cell1.setCellValue("5");
        cell1 = row91.createCell(3);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getFlexion().getActual_right());
        cell1 = row91.createCell(4);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getFlexion().getActual_left());
        cell1 = row91.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getFlexion().getPerc_loss_right());
        cell1 = row91.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getFlexion().getPerc_loss_left());
        cell1 = row91.createCell(7);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getInner_calculations().getMean_loss_right());
        cell1 = row91.createCell(8);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getInner_calculations().getMean_loss_left());
        cell1 = row91.createCell(9);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getInner_calculations().getMean_loss_right() * 0.3);
        cell1 = row91.createCell(10);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getInner_calculations().getMean_loss_left() * 0.3);

        final Row row92 = sheet1.createRow(92);
        cell1 = row92.createCell(0);
        cell1 = row92.createCell(1);
        cell1.setCellValue("Extension");
        cell1 = row92.createCell(2);
        cell1.setCellValue("5");
        cell1 = row92.createCell(3);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getExtension().getActual_right());
        cell1 = row92.createCell(4);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getExtension().getActual_left());
        cell1 = row92.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getExtension().getPerc_loss_right());
        cell1 = row92.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getExtension().getPerc_loss_left());

        final Row row93 = sheet1.createRow(93);
        cell1 = row93.createCell(0);
        cell1 = row93.createCell(1);
        cell1.setCellValue("Internal Rotation");
        cell1 = row93.createCell(2);
        cell1.setCellValue("5");
        cell1 = row93.createCell(3);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getInternal_rotation().getActual_right());
        cell1 = row93.createCell(4);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getInternal_rotation().getActual_left());
        cell1 = row93.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getInternal_rotation().getPerc_loss_right());
        cell1 = row93.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getInternal_rotation().getPerc_loss_left());

        final Row row94 = sheet1.createRow(94);
        cell1 = row94.createCell(0);
        cell1 = row94.createCell(1);
        cell1.setCellValue("External Rotation");
        cell1 = row94.createCell(2);
        cell1.setCellValue("5");
        cell1 = row94.createCell(3);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getExternal_rotation().getActual_right());
        cell1 = row94.createCell(4);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getExternal_rotation().getActual_left());
        cell1 = row94.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getExternal_rotation().getPerc_loss_right());
        cell1 = row94.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getExternal_rotation().getPerc_loss_left());


        final Row row95 = sheet1.createRow(95);
        cell1 = row95.createCell(0);
        cell1 = row95.createCell(1);
        cell1.setCellValue("Adduction");
        cell1 = row95.createCell(2);
        cell1.setCellValue("5");
        cell1 = row95.createCell(3);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getAdduction().getActual_right());
        cell1 = row95.createCell(4);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getAdduction().getActual_left());
        cell1 = row95.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getAdduction().getPerc_loss_right());
        cell1 = row95.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getAdduction().getPerc_loss_left());


        final Row row96 = sheet1.createRow(96);
        cell1 = row96.createCell(0);
        cell1 = row96.createCell(1);
        cell1.setCellValue("Abduction");
        cell1 = row96.createCell(2);
        cell1.setCellValue("5");
        cell1 = row96.createCell(3);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getAbduction().getActual_right());
        cell1 = row96.createCell(4);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getAbduction().getActual_left());
        cell1 = row96.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getAbduction().getPerc_loss_right());
        cell1 = row96.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_hip().getAbduction().getPerc_loss_left());


        //KNEE
        final Row row97 = sheet1.createRow(97);
        cell1 = row97.createCell(0);
        cell1.setCellValue("KNEE");
        cell1 = row97.createCell(1);
        cell1.setCellValue("Flexion");
        cell1 = row97.createCell(2);
        cell1.setCellValue("5");
        cell1 = row97.createCell(3);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_knee().getFlexion().getActual_right());
        cell1 = row97.createCell(4);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_knee().getFlexion().getActual_left());
        cell1 = row97.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_knee().getFlexion().getPerc_loss_right());
        cell1 = row97.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_knee().getFlexion().getPerc_loss_left());
        cell1 = row97.createCell(7);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_knee().getInner_calculations().getMean_loss_right());
        cell1 = row97.createCell(8);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_knee().getInner_calculations().getMean_loss_left());
        cell1 = row97.createCell(9);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_knee().getInner_calculations().getMean_loss_right() * 0.3);
        cell1 = row97.createCell(10);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_knee().getInner_calculations().getMean_loss_left() * 0.3);


        final Row row98 = sheet1.createRow(98);
        cell1 = row98.createCell(0);
        cell1 = row98.createCell(1);
        cell1.setCellValue("Extension");
        cell1 = row98.createCell(2);
        cell1.setCellValue("5");
        cell1 = row98.createCell(3);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_knee().getExtension().getActual_right());
        cell1 = row98.createCell(4);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_knee().getExtension().getActual_left());
        cell1 = row98.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_knee().getExtension().getPerc_loss_right());
        cell1 = row98.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_knee().getExtension().getPerc_loss_left());

        //ANKLE AND FOOT
        final Row row99 = sheet1.createRow(99);
        cell1 = row99.createCell(0);
        cell1.setCellValue("ANKLE & FOOT");
        cell1 = row99.createCell(1);
        cell1.setCellValue("Dorsiflexion");
        cell1 = row99.createCell(2);
        cell1.setCellValue("5");
        cell1 = row99.createCell(3);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_ankleFoot().getDorsiflexion().getActual_right());
        cell1 = row99.createCell(4);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_ankleFoot().getDorsiflexion().getActual_left());
        cell1 = row99.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_ankleFoot().getDorsiflexion().getPerc_loss_right());
        cell1 = row99.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_ankleFoot().getDorsiflexion().getPerc_loss_left());
        cell1 = row99.createCell(7);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_ankleFoot().getInner_calculations().getMean_loss_right());
        cell1 = row99.createCell(8);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_ankleFoot().getInner_calculations().getMean_loss_left());
        cell1 = row99.createCell(9);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_ankleFoot().getInner_calculations().getMean_loss_right() * 0.3);
        cell1 = row99.createCell(10);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_ankleFoot().getInner_calculations().getMean_loss_left() * 0.3);

        final Row row100 = sheet1.createRow(100);
        cell1 = row100.createCell(0);
        cell1 = row100.createCell(1);
        cell1.setCellValue("Plantar flexion");
        cell1 = row100.createCell(2);
        cell1.setCellValue("5");
        cell1 = row100.createCell(3);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_ankleFoot().getPlantar_flexion().getActual_right());
        cell1 = row100.createCell(4);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_ankleFoot().getPlantar_flexion().getActual_left());
        cell1 = row100.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_ankleFoot().getPlantar_flexion().getPerc_loss_right());
        cell1 = row100.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_ankleFoot().getPlantar_flexion().getPerc_loss_left());

        final Row row101 = sheet1.createRow(101);
        cell1 = row101.createCell(0);
        cell1 = row101.createCell(1);
        cell1.setCellValue("Inversion");
        cell1 = row101.createCell(2);
        cell1.setCellValue("5");
        cell1 = row101.createCell(3);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_ankleFoot().getInversion().getActual_right());
        cell1 = row101.createCell(4);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_ankleFoot().getInversion().getActual_left());
        cell1 = row101.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_ankleFoot().getInversion().getPerc_loss_right());
        cell1 = row101.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_ankleFoot().getInversion().getPerc_loss_left());

        final Row row102 = sheet1.createRow(102);
        cell1 = row102.createCell(0);
        cell1 = row102.createCell(1);
        cell1.setCellValue("Eversion");
        cell1 = row102.createCell(2);
        cell1.setCellValue("5");
        cell1 = row102.createCell(3);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_ankleFoot().getEversion().getActual_right());
        cell1 = row102.createCell(4);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_ankleFoot().getEversion().getActual_left());
        cell1 = row102.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_ankleFoot().getEversion().getPerc_loss_right());
        cell1 = row102.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_ankleFoot().getEversion().getPerc_loss_left());

       /* final Row row102 = sheet1.createRow(102);
        cell1 = row102.createCell(0);
        cell1 = row102.createCell(1);
        cell1.setCellValue("Eversion");
        cell1 = row102.createCell(2);
        cell1.setCellValue("5");
        cell1 = row102.createCell(3);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_knee().getFlexion().getActual_right());
        cell1 = row102.createCell(4);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_knee().getFlexion().getActual_left());
        cell1 = row102.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_knee().getFlexion().getPerc_loss_right());
        cell1 = row102.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_muscle_power().
                getC_llmp_knee().getFlexion().getPerc_loss_left());*/

        //SUMMATION
        final Row row103 = sheet1.createRow(103);
        cell1 = row103.createCell(0);
        cell1 = row103.createCell(9);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getInnerCalculations().getSummation_left());
        cell1 = row103.createCell(10);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLowerLimb_active_rom_degrees().getInnerCalculations().getSummation_right());


        //MOBILITY COMPONENT
        final Row row105 = sheet1.createRow(105);
        cell1 = row105.createCell(0);
        cell1.setCellValue("MOBILITY COMPONENT");
        cell1 = row105.createCell(1);
        cell1.setCellValue("ROM + POWER");
        cell1 = row105.createCell(2);
        cell1.setCellValue("max. 90% Addition by");
        cell1 = row105.createCell(9);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getMobilityComponentRight());
        cell1 = row105.createCell(10);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getMobilityComponentLeft());

        final Row row106 = sheet1.createRow(106);
        cell1 = row106.createCell(0);
        cell1.setCellValue("LOSS IN STABILITY COMPONENT (max.10% each)");
        cell1 = row106.createCell(1);
        cell1.setCellValue("Walking on plain surface");
        cell1 = row106.createCell(2);
        cell1.setCellValue("0%");
        cell1 = row106.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobility_component().
                getWalkingPlainSurface().getActual_right());
        cell1 = row106.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobility_component().
                getWalkingPlainSurface().getActual_left());
        cell1 = row106.createCell(9);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobility_component().
                getInner_calculations().getSummation_right());
        cell1 = row106.createCell(10);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobility_component().
                getInner_calculations().getSummation_left());

        final Row row107 = sheet1.createRow(107);
        cell1 = row107.createCell(0);
        cell1 = row107.createCell(1);
        cell1.setCellValue("Walking on Slope");
        cell1 = row107.createCell(2);
        cell1.setCellValue("0%");
        cell1 = row107.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobility_component().
                getWalkingSlope().getActual_right());
        cell1 = row107.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobility_component().
                getWalkingSlope().getActual_left());
        cell1 = row107.createCell(9);

        final Row row108 = sheet1.createRow(108);
        cell1 = row108.createCell(0);
        cell1 = row108.createCell(1);
        cell1.setCellValue("Climbing Stairs");
        cell1 = row108.createCell(2);
        cell1.setCellValue("0%");
        cell1 = row108.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobility_component().
                getClimbingStairs().getActual_right());
        cell1 = row108.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobility_component().
                getClimbingStairs().getActual_left());
        cell1 = row108.createCell(9);

        final Row row109 = sheet1.createRow(109);
        cell1 = row109.createCell(0);
        cell1 = row109.createCell(1);
        cell1.setCellValue("Standing on both legs");
        cell1 = row109.createCell(2);
        cell1.setCellValue("0%");
        cell1 = row109.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobility_component().
                getStandingBothLegs().getActual_right());
        cell1 = row109.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobility_component().
                getStandingBothLegs().getActual_left());
        cell1 = row109.createCell(9);

        final Row row110 = sheet1.createRow(110);
        cell1 = row110.createCell(0);
        cell1 = row110.createCell(1);
        cell1.setCellValue("Standing on affected leg");
        cell1 = row110.createCell(2);
        cell1.setCellValue("0%");
        cell1 = row110.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobility_component().
                getStandingAffectedLeg().getActual_right());
        cell1 = row110.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobility_component().
                getStandingAffectedLeg().getActual_left());
        cell1 = row110.createCell(9);

        final Row row111 = sheet1.createRow(111);
        cell1 = row111.createCell(0);
        cell1 = row111.createCell(1);
        cell1.setCellValue("Squatting");
        cell1 = row111.createCell(2);
        cell1.setCellValue("0%");
        cell1 = row111.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobility_component().
                getSquatting().getActual_right());
        cell1 = row111.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobility_component().
                getSquatting().getActual_left());
        cell1 = row111.createCell(9);

        final Row row112 = sheet1.createRow(112);
        cell1 = row112.createCell(0);
        cell1 = row112.createCell(1);
        cell1.setCellValue("Sitting Cross legged");
        cell1 = row112.createCell(2);
        cell1.setCellValue("0%");
        cell1 = row112.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobility_component().
                getSittingCrossLegged().getActual_right());
        cell1 = row112.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobility_component().
                getSittingCrossLegged().getActual_left());

        final Row row113 = sheet1.createRow(113);
        cell1 = row113.createCell(0);
        cell1 = row113.createCell(1);
        cell1.setCellValue("Kneeling");
        cell1 = row113.createCell(2);
        cell1.setCellValue("0%");
        cell1 = row113.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobility_component().
                getKneeling().getActual_right());
        cell1 = row113.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobility_component().
                getKneeling().getActual_left());

        final Row row114 = sheet1.createRow(114);
        cell1 = row114.createCell(0);
        cell1 = row114.createCell(1);
        cell1.setCellValue("Taking Turns");
        cell1 = row114.createCell(2);
        cell1.setCellValue("0%");
        cell1 = row114.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobility_component().
                getTakingTurns().getActual_right());
        cell1 = row114.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobility_component().
                getTakingTurns().getActual_left());
        cell1 = row114.createCell(9);

        final Row row115 = sheet1.createRow(115);
        cell1 = row115.createCell(0);
        cell1.setCellValue("Total");
        cell1 = row115.createCell(1);
        cell1 = row115.createCell(2);
        cell1.setCellValue("max. 90%");


        //COMBINING MOBILITY & STABILITY

        final Row row116 = sheet1.createRow(116);
        cell1 = row116.createCell(0);
        cell1.setCellValue("COMBINING MOBILITY & STABILITY");
        cell1 = row116.createCell(1);
        cell1 = row116.createCell(2);
        cell1.setCellValue("90%");
        cell1 = row116.createCell(9);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getCombMobStabCompRIGHT());
        cell1 = row116.createCell(10);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getCombMobStabCompLEFT());

        final Row row117 = sheet1.createRow(117);
        cell1 = row117.createCell(0);
        cell1.setCellValue("EXTRA POINTS");
        cell1 = row117.createCell(1);
        cell1.setCellValue("PAIN - Mild");
        cell1 = row117.createCell(2);
        cell1.setCellValue("3%");

        final Row row118 = sheet1.createRow(118);
        cell1 = row118.createCell(0);
        cell1 = row118.createCell(1);
        cell1.setCellValue("PAIN - Moderate");
        cell1 = row118.createCell(2);
        cell1.setCellValue("6%");

        final Row row119 = sheet1.createRow(119);
        cell1 = row119.createCell(0);
        cell1 = row119.createCell(1);
        cell1.setCellValue("PAIN - Severe");
        cell1 = row119.createCell(2);
        cell1.setCellValue("9%");

        final Row row120 = sheet1.createRow(120);
        cell1 = row120.createCell(0);
        cell1 = row120.createCell(1);
        cell1.setCellValue("DEFORMITY in functional position");
        cell1 = row120.createCell(2);
        cell1.setCellValue("3%");

        final Row row121 = sheet1.createRow(121);
        cell1 = row121.createCell(0);
        cell1 = row121.createCell(1);
        cell1.setCellValue("DEFORMITY in non functional position");
        cell1 = row121.createCell(2);
        cell1.setCellValue("6%");

        final Row row122 = sheet1.createRow(122);
        cell1 = row122.createCell(0);
        cell1 = row122.createCell(1);
        cell1.setCellValue("LOSS OF SENSATION - Partial");
        cell1 = row122.createCell(2);
        cell1.setCellValue("6%");
        cell1 = row122.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobStab_extraPoints().getExtraPoints().getActual_right());
        cell1 = row122.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobStab_extraPoints().getExtraPoints().getActual_left());
        cell1 = row122.createCell(9);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobStab_extraPoints().getExtraPoints().getActual_right());
        cell1 = row122.createCell(10);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobStab_extraPoints().getExtraPoints().getActual_left());


        final Row row123 = sheet1.createRow(123);
        cell1 = row123.createCell(0);
        cell1 = row123.createCell(1);
        cell1.setCellValue("LOSS OF SENSATION - Complete");
        cell1 = row123.createCell(2);
        cell1.setCellValue("9%");

        final Row row124 = sheet1.createRow(124);
        cell1 = row124.createCell(0);
        cell1 = row124.createCell(1);
        cell1.setCellValue("COMPLICATIONS - Superficial");
        cell1 = row124.createCell(2);
        cell1.setCellValue("3%");

        final Row row125 = sheet1.createRow(125);
        cell1 = row125.createCell(0);
        cell1 = row125.createCell(1);
        cell1.setCellValue("COMPLICATIONS - Deep");
        cell1 = row125.createCell(2);
        cell1.setCellValue("6%");


        final Row row126 = sheet1.createRow(126);
        cell1 = row126.createCell(0);
        cell1 = row126.createCell(1);
        cell1.setCellValue("TOTAL");
        cell1 = row126.createCell(2);
        cell1.setCellValue("10% max");

        final Row row127 = sheet1.createRow(127);
        cell1 = row127.createCell(0);
        cell1 = row127.createCell(1);
        cell1.setCellValue("SHORTENING - First Half Inch");
        cell1 = row127.createCell(2);
        cell1.setCellValue("0%");
        cell1 = row127.createCell(5);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobStab_extraPoints().getShorteningPoints().getActual_right());
        cell1 = row127.createCell(6);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobStab_extraPoints().getShorteningPoints().getActual_left());
        cell1 = row127.createCell(9);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobStab_extraPoints().getShorteningPoints().getActual_right());
        cell1 = row127.createCell(10);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getLower_limb_mobStab_extraPoints().getShorteningPoints().getActual_left());

        final Row row128 = sheet1.createRow(128);
        cell1 = row128.createCell(0);
        cell1 = row128.createCell(1);
        cell1.setCellValue("SHORTENING - Every additional Half Inch");
        cell1 = row128.createCell(2);
        cell1.setCellValue("4%");

        final Row row129 = sheet1.createRow(129);
        cell1 = row129.createCell(0);
        cell1.setCellValue("TOTAL L/L COMPONENT");
        cell1 = row129.createCell(1);
        cell1 = row129.createCell(2);
        cell1.setCellValue("100% max");
        cell1 = row129.createCell(9);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getTotalLLComponentRIGHT());
        cell1 = row129.createCell(10);
        cell1.setCellValue(finalDto.getClass_lowerLimb_component().getTotalLLComponentLEFT());


        //AMPUTATION

        final Row row131 = sheet1.createRow(131);
        cell1 = row131.createCell(0);
        cell1.setCellValue("Function / Parameter");
        cell1 = row131.createCell(1);
        cell1.setCellValue("Max. Value");

        final Row row132 = sheet1.createRow(132);
        cell1 = row132.createCell(0);
        cell1.setCellValue("III.AMPUTATION");

        final Row row133 = sheet1.createRow(133);
        cell1 = row133.createCell(0);
        cell1.setCellValue("UPPER LIMB");

        final Row row134 = sheet1.createRow(134);
        cell1 = row134.createCell(0);
        cell1.setCellValue("Fore quarter Amputation");
        cell1 = row134.createCell(1);
        cell1.setCellValue("100%");

        final Row row135 = sheet1.createRow(135);
        cell1 = row135.createCell(0);
        cell1.setCellValue("Shoulder Disarticulation");
        cell1 = row135.createCell(1);
        cell1.setCellValue("90%");

        final Row row136 = sheet1.createRow(136);
        cell1 = row136.createCell(0);
        cell1.setCellValue("A/E upto upper 1/3 of arm");
        cell1 = row136.createCell(1);
        cell1.setCellValue("85%");

        final Row row137 = sheet1.createRow(137);
        cell1 = row137.createCell(0);
        cell1.setCellValue("A/E upto lower 1/3 of arm");
        cell1 = row137.createCell(1);
        cell1.setCellValue("80%");

        final Row row138 = sheet1.createRow(138);
        cell1 = row138.createCell(0);
        cell1.setCellValue("Elbow Disarticulation");
        cell1 = row138.createCell(1);
        cell1.setCellValue("75%");

        final Row row139 = sheet1.createRow(139);
        cell1 = row139.createCell(0);
        cell1.setCellValue("B/E upto upper 1/3 of arm");
        cell1 = row139.createCell(1);
        cell1.setCellValue("70%");

        final Row row140 = sheet1.createRow(140);
        cell1 = row140.createCell(0);
        cell1.setCellValue("B/E upto lower 1/3 of arm");
        cell1 = row140.createCell(1);
        cell1.setCellValue("65%");

        final Row row141 = sheet1.createRow(141);
        cell1 = row141.createCell(0);
        cell1.setCellValue("Wrist Disarticulation");
        cell1 = row141.createCell(1);
        cell1.setCellValue("60%");

        final Row row142 = sheet1.createRow(142);
        cell1 = row142.createCell(0);
        cell1.setCellValue("Hand through Carpal Bones");
        cell1 = row142.createCell(1);
        cell1.setCellValue("55%");

        final Row row143 = sheet1.createRow(143);
        cell1 = row143.createCell(0);
        cell1.setCellValue("Thumb through CM / MCP Joint");
        cell1 = row143.createCell(1);
        cell1.setCellValue("30%");

        final Row row144 = sheet1.createRow(144);
        cell1 = row144.createCell(0);
        cell1.setCellValue("Thumb disarticulation through Proximal Plalynx");
        cell1 = row144.createCell(1);
        cell1.setCellValue("25%");
        cell1 = row144.createCell(3);
        cell1.setCellValue(finalDto.getAmputation().getUpper_amputaion().getActual_right());
        cell1 = row144.createCell(4);
        cell1.setCellValue(finalDto.getAmputation().getUpper_amputaion().getActual_left());

        final Row row145 = sheet1.createRow(145);
        cell1 = row145.createCell(0);
        cell1.setCellValue("Thumb disarticulation through Distal Plalynx or IP");
        cell1 = row145.createCell(1);
        cell1.setCellValue("15%");

        final Row row146 = sheet1.createRow(146);
        cell1 = row146.createCell(0);
        cell1.setCellValue("Index Finger - PP / MCPn");
        cell1 = row146.createCell(1);
        cell1.setCellValue("15%");

        final Row row147 = sheet1.createRow(147);
        cell1 = row147.createCell(0);
        cell1.setCellValue("MP / PIP");
        cell1 = row147.createCell(1);
        cell1.setCellValue("10%");

        final Row row148 = sheet1.createRow(148);
        cell1 = row148.createCell(0);
        cell1.setCellValue("DP / DIP");
        cell1 = row148.createCell(1);
        cell1.setCellValue("5%");

        final Row row149 = sheet1.createRow(149);
        cell1 = row149.createCell(0);
        cell1.setCellValue("Middle Finger - PP / MCP");
        cell1 = row149.createCell(1);
        cell1.setCellValue("5%");

        final Row row150 = sheet1.createRow(150);
        cell1 = row150.createCell(0);
        cell1.setCellValue("MP / PIP");
        cell1 = row150.createCell(1);
        cell1.setCellValue("4%");

        final Row row151 = sheet1.createRow(151);
        cell1 = row151.createCell(0);
        cell1.setCellValue("DP / DIP");
        cell1 = row151.createCell(1);
        cell1.setCellValue("2%");

        final Row row152 = sheet1.createRow(152);
        cell1 = row152.createCell(0);
        cell1.setCellValue("Ring Finger - PP / MCP");
        cell1 = row152.createCell(1);
        cell1.setCellValue("3%");

        final Row row153 = sheet1.createRow(153);
        cell1 = row153.createCell(0);
        cell1.setCellValue("MP / PIP");
        cell1 = row153.createCell(1);
        cell1.setCellValue("2%");

        final Row row154 = sheet1.createRow(154);
        cell1 = row154.createCell(0);
        cell1.setCellValue("DP / DIP");
        cell1 = row154.createCell(1);
        cell1.setCellValue("1%");

        final Row row155 = sheet1.createRow(155);
        cell1 = row155.createCell(0);
        cell1.setCellValue("Little Finger - PP / MCP");
        cell1 = row155.createCell(1);
        cell1.setCellValue("2%");

        final Row row156 = sheet1.createRow(156);
        cell1 = row156.createCell(0);
        cell1.setCellValue("MP / PIP");
        cell1 = row156.createCell(1);
        cell1.setCellValue("1%");

        final Row row157 = sheet1.createRow(157);
        cell1 = row157.createCell(0);
        cell1.setCellValue("DP / DIP");
        cell1 = row157.createCell(1);
        cell1.setCellValue("1%");

        //AMPUTATION LOWER LIMB
        final Row row158 = sheet1.createRow(158);
        cell1 = row158.createCell(0);
        cell1.setCellValue("LOWER LIMB");

        final Row row159 = sheet1.createRow(159);
        cell1 = row159.createCell(0);
        cell1.setCellValue("Hind quarter Amputation");
        cell1 = row159.createCell(1);
        cell1.setCellValue("100%");

        final Row row160 = sheet1.createRow(160);
        cell1 = row160.createCell(0);
        cell1.setCellValue("Hip Disarticulation");
        cell1 = row160.createCell(1);
        cell1.setCellValue("90%");

        final Row row161 = sheet1.createRow(161);
        cell1 = row161.createCell(0);
        cell1.setCellValue("A/K upto upper 1/3 of thigh");
        cell1 = row161.createCell(1);
        cell1.setCellValue("85%");

        final Row row162 = sheet1.createRow(162);
        cell1 = row162.createCell(0);
        cell1.setCellValue("A/K upto lower 1/3 of thigh");
        cell1 = row162.createCell(1);
        cell1.setCellValue("80%");

        final Row row163 = sheet1.createRow(163);
        cell1 = row163.createCell(0);
        cell1.setCellValue("Knee Diaarticulation");
        cell1 = row163.createCell(1);
        cell1.setCellValue("75%");

        final Row row164 = sheet1.createRow(164);
        cell1 = row164.createCell(0);
        cell1.setCellValue("B/K upto upper 1/3 of leg");
        cell1 = row164.createCell(1);
        cell1.setCellValue("70%");

        final Row row165 = sheet1.createRow(165);
        cell1 = row165.createCell(0);
        cell1.setCellValue("B/K upto lower 1/3 of leg");
        cell1 = row165.createCell(1);
        cell1.setCellValue("60%");

        final Row row166 = sheet1.createRow(166);
        cell1 = row166.createCell(0);
        cell1.setCellValue("Ankle Diasrticulation");
        cell1 = row166.createCell(1);
        cell1.setCellValue("55%");
        cell1 = row166.createCell(3);
        cell1.setCellValue(finalDto.getAmputation().getLower_amputation().getActual_right());
        cell1 = row166.createCell(4);
        cell1.setCellValue(finalDto.getAmputation().getLower_amputation().getActual_left());

        final Row row167 = sheet1.createRow(167);
        cell1 = row167.createCell(0);
        cell1.setCellValue("Syme's Amputation");
        cell1 = row167.createCell(1);
        cell1.setCellValue("50%");

        final Row row168 = sheet1.createRow(168);
        cell1 = row168.createCell(0);
        cell1.setCellValue("Chopart's Amputation");
        cell1 = row168.createCell(1);
        cell1.setCellValue("40%");

        final Row row169 = sheet1.createRow(169);
        cell1 = row169.createCell(0);
        cell1.setCellValue("Lis Franc Amputation");
        cell1 = row169.createCell(1);
        cell1.setCellValue("30%");

        final Row row170 = sheet1.createRow(170);
        cell1 = row170.createCell(0);
        cell1.setCellValue("All Toes");
        cell1 = row170.createCell(1);
        cell1.setCellValue("20%");

        final Row row171 = sheet1.createRow(171);
        cell1 = row171.createCell(0);
        cell1.setCellValue("Loss of first Toe");
        cell1 = row171.createCell(1);
        cell1.setCellValue("10%");

        final Row row172 = sheet1.createRow(172);
        cell1 = row172.createCell(0);
        cell1.setCellValue("Loss of second Toe");
        cell1 = row172.createCell(1);
        cell1.setCellValue("5%");

        final Row row173 = sheet1.createRow(173);
        cell1 = row173.createCell(0);
        cell1.setCellValue("Loss of third Toe");
        cell1 = row173.createCell(1);
        cell1.setCellValue("4%");

        final Row row174 = sheet1.createRow(174);
        cell1 = row174.createCell(0);
        cell1.setCellValue("Loss of fourth Toe");
        cell1 = row174.createCell(1);
        cell1.setCellValue("3%");

        final Row row175 = sheet1.createRow(175);
        cell1 = row175.createCell(0);
        cell1.setCellValue("Loss of fifth Toe");
        cell1 = row175.createCell(1);
        cell1.setCellValue("2%");

        final Row row176 = sheet1.createRow(176);
        cell1 = row176.createCell(0);
        cell1.setCellValue("SUBTOTAL");
        cell1 = row176.createCell(4);
        cell1.setCellValue(finalDto.getAmputation().getSubtotal());

        final Row row177 = sheet1.createRow(177);
        cell1 = row177.createCell(0);
        cell1.setCellValue("ADDITIONAL POINTS");

        final Row row178 = sheet1.createRow(178);
        cell1 = row178.createCell(0);
        cell1.setCellValue("Stump unfit for prosthesis");
        cell1 = row178.createCell(1);
        cell1.setCellValue("5%");

        final Row row179 = sheet1.createRow(179);
        cell1 = row179.createCell(0);
        cell1.setCellValue("Dominant Upper Extremity");
        cell1 = row179.createCell(1);
        cell1.setCellValue("10%");

        final Row row180 = sheet1.createRow(180);
        cell1 = row180.createCell(0);
        cell1.setCellValue("Stiffness of Proximal Joint / Neuroma / Infection");
        cell1 = row180.createCell(1);
        cell1.setCellValue("10%");

        final Row row181 = sheet1.createRow(181);
        cell1 = row181.createCell(0);
        cell1.setCellValue("Multiple Limb involvement (Toes / Fingers)");
        cell1 = row181.createCell(1);
        cell1.setCellValue("5%");
        cell1 = row181.createCell(4);
        cell1.setCellValue(finalDto.getAmputation().getAdditionlPointsAmp());


        final Row row182 = sheet1.createRow(182);
        cell1 = row182.createCell(0);
        cell1.setCellValue("Multiple Limb involvement (Beyond Toes / Fingers)");
        cell1 = row182.createCell(1);
        cell1.setCellValue("10%");

        final Row row183 = sheet1.createRow(183);
        cell1 = row183.createCell(0);
        cell1.setCellValue("TOTAL AMPUTATION DISABILITY");
        cell1 = row183.createCell(1);
        cell1.setCellValue("max.100%");
        cell1 = row183.createCell(4);
        cell1.setCellValue(finalDto.getAmputation().getTotalAmpDisability());

        //DWARFISM
        final Row row184 = sheet1.createRow(184);
        cell1 = row184.createCell(0);
        cell1.setCellValue("IV.DWARFISM");

        final Row row185 = sheet1.createRow(185);
        cell1 = row185.createCell(0);
        cell1.setCellValue("Every inch of vertical height loss w.r.t. ICMR Chart");
        cell1 = row185.createCell(1);
        cell1.setCellValue("4%");
        cell1 = row185.createCell(4);
        cell1.setCellValue(finalDto.getDwarfism().getDwarfismValue());


        //CONGENITAL DEFICIECIES

        final Row row186 = sheet1.createRow(186);
        cell1 = row186.createCell(0);
        cell1.setCellValue("V.CONGENITAL DEFICIENCIES");

        final Row row187 = sheet1.createRow(187);
        cell1 = row187.createCell(0);
        cell1.setCellValue("TRANSVERSE");

        final Row row188 = sheet1.createRow(188);
        cell1 = row188.createCell(0);
        cell1.setCellValue("Right Arm Complete");
        cell1 = row188.createCell(1);
        cell1.setCellValue("90%");

        final Row row189 = sheet1.createRow(189);
        cell1 = row189.createCell(0);
        cell1.setCellValue("Thigh Complete");
        cell1 = row189.createCell(1);
        cell1.setCellValue("90%");

        final Row row190 = sheet1.createRow(190);
        cell1 = row190.createCell(0);
        cell1.setCellValue("Proximal Upper Arm");
        cell1 = row190.createCell(1);
        cell1.setCellValue("85%");

        final Row row191 = sheet1.createRow(191);
        cell1 = row191.createCell(0);
        cell1.setCellValue("Lower Thigh");
        cell1 = row191.createCell(1);
        cell1.setCellValue("80%");
        cell1 = row191.createCell(3);
        cell1.setCellValue(finalDto.getCongenitalDeficiencies().getTransverse().getActual_right());
        cell1 = row191.createCell(4);
        cell1.setCellValue(finalDto.getCongenitalDeficiencies().getTransverse().getActual_left());

        final Row row192 = sheet1.createRow(192);
        cell1 = row192.createCell(0);
        cell1.setCellValue("Forearm Complete");
        cell1 = row192.createCell(1);
        cell1.setCellValue("75%");

        final Row row193 = sheet1.createRow(193);
        cell1 = row193.createCell(0);
        cell1.setCellValue("Lower Forearm");
        cell1 = row193.createCell(1);
        cell1.setCellValue("65%");

        final Row row194 = sheet1.createRow(194);
        cell1 = row194.createCell(0);
        cell1.setCellValue("Carpal Complete");
        cell1 = row194.createCell(1);
        cell1.setCellValue("60%");

        final Row row195 = sheet1.createRow(195);
        cell1 = row195.createCell(0);
        cell1.setCellValue("Metacarpal Complete");
        cell1 = row195.createCell(1);
        cell1.setCellValue("55%");

        final Row row196 = sheet1.createRow(196);
        cell1 = row196.createCell(0);
        cell1.setCellValue("CLUBFOOT (Pirani Score)");

        final Row row197 = sheet1.createRow(197);
        cell1 = row197.createCell(0);
        cell1.setCellValue("6");
        cell1 = row197.createCell(1);
        cell1.setCellValue("40%");

        final Row row198 = sheet1.createRow(198);
        cell1 = row198.createCell(0);
        cell1.setCellValue("5.5");
        cell1 = row198.createCell(1);
        cell1.setCellValue("37%");

        final Row row199 = sheet1.createRow(199);
        cell1 = row199.createCell(0);
        cell1.setCellValue("5");
        cell1 = row199.createCell(1);
        cell1.setCellValue("35%");

        final Row row200 = sheet1.createRow(200);
        cell1 = row200.createCell(0);
        cell1.setCellValue("4.5");
        cell1 = row200.createCell(1);
        cell1.setCellValue("31%");

        final Row row201 = sheet1.createRow(201);
        cell1 = row201.createCell(0);
        cell1.setCellValue("4");
        cell1 = row201.createCell(1);
        cell1.setCellValue("27%");

        final Row row202 = sheet1.createRow(202);
        cell1 = row202.createCell(0);
        cell1.setCellValue("3.5");
        cell1 = row202.createCell(1);
        cell1.setCellValue("24%");

        final Row row203 = sheet1.createRow(203);
        cell1 = row203.createCell(0);
        cell1.setCellValue("3");
        cell1 = row203.createCell(1);
        cell1.setCellValue("20%");
        cell1 = row203.createCell(3);
        cell1.setCellValue(finalDto.getCongenitalDeficiencies().getClubfoot().getActual_right());
        cell1 = row203.createCell(4);
        cell1.setCellValue(finalDto.getCongenitalDeficiencies().getClubfoot().getActual_left());

        final Row row204 = sheet1.createRow(204);
        cell1 = row204.createCell(0);
        cell1.setCellValue("2.5");
        cell1 = row204.createCell(1);
        cell1.setCellValue("17%");

        final Row row205 = sheet1.createRow(205);
        cell1 = row205.createCell(0);
        cell1.setCellValue("2");
        cell1 = row205.createCell(1);
        cell1.setCellValue("14%");

        final Row row206 = sheet1.createRow(206);
        cell1 = row206.createCell(0);
        cell1.setCellValue("1.5");
        cell1 = row206.createCell(1);
        cell1.setCellValue("10%");

        final Row row207 = sheet1.createRow(207);
        cell1 = row207.createCell(0);
        cell1.setCellValue("1");
        cell1 = row207.createCell(1);
        cell1.setCellValue("7%");

        final Row row208 = sheet1.createRow(208);
        cell1 = row208.createCell(0);
        cell1.setCellValue("0.5");
        cell1 = row208.createCell(1);
        cell1.setCellValue("3%");

        final Row row209 = sheet1.createRow(209);
        cell1 = row209.createCell(0);
        cell1.setCellValue("0");
        cell1 = row209.createCell(1);
        cell1.setCellValue("0%");

        final Row row210 = sheet1.createRow(210);
        cell1 = row210.createCell(0);
        cell1.setCellValue("TOTAL");
        cell1 = row210.createCell(4);
        cell1.setCellValue(finalDto.getCongenitalDeficiencies().getCalculation());


        //SPINAL AFFECTION
        final Row row211 = sheet1.createRow(211);
        cell1 = row211.createCell(0);
        cell1.setCellValue("VI.SPINAL AFFECTION");

        final Row row212 = sheet1.createRow(212);
        cell1 = row212.createCell(0);
        cell1.setCellValue("A.TRAUMATIC AFFECTION");

        final Row row213 = sheet1.createRow(213);
        cell1 = row213.createCell(0);
        cell1.setCellValue("Cervical Traumatic Lesions");

        final Row row214 = sheet1.createRow(214);
        cell1 = row214.createCell(0);
        cell1.setCellValue("25% or more of compression (post.elements spared)");
        cell1 = row214.createCell(1);
        cell1.setCellValue("20%");

        final Row row215 = sheet1.createRow(215);
        cell1 = row215.createCell(0);
        cell1.setCellValue("Posterior element damage with dislocation / subluxation -");

        final Row row216 = sheet1.createRow(216);
        cell1 = row216.createCell(0);
        cell1.setCellValue("reduced dislocation");
        cell1 = row216.createCell(1);
        cell1.setCellValue("10%");

        final Row row217 = sheet1.createRow(217);
        cell1 = row217.createCell(0);
        cell1.setCellValue("with fusion");
        cell1 = row217.createCell(1);
        cell1.setCellValue("10%");

        final Row row218 = sheet1.createRow(218);
        cell1 = row218.createCell(0);
        cell1.setCellValue("inadequte reduction with persistent pain");
        cell1 = row218.createCell(1);
        cell1.setCellValue("15%");

        final Row row219 = sheet1.createRow(219);
        cell1 = row219.createCell(0);
        cell1.setCellValue("with instability and pain");
        cell1 = row219.createCell(1);
        cell1.setCellValue("25%");

        final Row row220 = sheet1.createRow(220);
        cell1 = row220.createCell(0);
        cell1.setCellValue("Cervical Disc Lesions");

        final Row row221 = sheet1.createRow(221);
        cell1 = row221.createCell(0);
        cell1.setCellValue("Treated case with persistent pain but no deficit");
        cell1 = row221.createCell(1);
        cell1.setCellValue("10%");

        final Row row222 = sheet1.createRow(222);
        cell1 = row222.createCell(0);
        cell1.setCellValue("Treated case with persistent pain and instability");
        cell1 = row222.createCell(1);
        cell1.setCellValue("15%");

        final Row row223 = sheet1.createRow(223);
        cell1 = row223.createCell(0);
        cell1.setCellValue("Thoracic Traumatic Lesions");

        final Row row224 = sheet1.createRow(224);
        cell1 = row224.createCell(0);
        cell1.setCellValue("Compression of single body less than 50% without deficit");
        cell1 = row224.createCell(1);
        cell1.setCellValue("10%");

        final Row row225 = sheet1.createRow(225);
        cell1 = row225.createCell(0);
        cell1.setCellValue("Compression more than 50% with post.elements, no pain");
        cell1 = row225.createCell(1);
        cell1.setCellValue("15%");

        final Row row226 = sheet1.createRow(226);
        cell1 = row226.createCell(0);
        cell1.setCellValue("Compression more than 50% with post.elements, persistent pain");
        cell1 = row226.createCell(1);
        cell1.setCellValue("20%");


        final Row row227 = sheet1.createRow(227);
        cell1 = row227.createCell(0);
        cell1.setCellValue("Instability with fracture / dislocation with persistent pain");
        cell1 = row227.createCell(1);
        cell1.setCellValue("30%");
        cell1 = row227.createCell(4);
        cell1.setCellValue(finalDto.getClass_spinal_affection().getC_traumetic_affection().getTraumeticAfffection());

        final Row row228 = sheet1.createRow(228);
        cell1 = row228.createCell(0);
        cell1.setCellValue("Lumbar Traumatic Lesions");

        final Row row229 = sheet1.createRow(229);
        cell1 = row229.createCell(0);
        cell1.setCellValue("Compression less than 25% (one or two vertebra) without deficit");
        cell1 = row229.createCell(1);
        cell1.setCellValue("10%");

        final Row row230 = sheet1.createRow(230);
        cell1 = row230.createCell(0);
        cell1.setCellValue("Compression more than 25% with post.elements involved and pain");
        cell1 = row230.createCell(1);
        cell1.setCellValue("20%");

        final Row row231 = sheet1.createRow(231);
        cell1 = row231.createCell(0);
        cell1.setCellValue("Instability with pain");

        final Row row232 = sheet1.createRow(232);
        cell1 = row232.createCell(0);
        cell1.setCellValue("Lumbar Disc Lesions");
        cell1 = row232.createCell(1);
        cell1.setCellValue("3%");

        final Row row233 = sheet1.createRow(233);
        cell1 = row233.createCell(0);
        cell1.setCellValue("Treated case with persistent pain");
        cell1 = row233.createCell(1);
        cell1.setCellValue("10%");

        final Row row234 = sheet1.createRow(234);
        cell1 = row234.createCell(0);
        cell1.setCellValue("Treated case with persistent pain & instability");
        cell1 = row234.createCell(1);
        cell1.setCellValue("20%");

        final Row row235 = sheet1.createRow(235);
        cell1 = row235.createCell(0);
        cell1.setCellValue("Treated case with persistent pain & moderate lifestyle modification");
        cell1 = row235.createCell(1);
        cell1.setCellValue("25%");


        final Row row236 = sheet1.createRow(236);
        cell1 = row236.createCell(0);
        cell1.setCellValue("Treated case with persistent pain & severe lifestyle modification");
        cell1 = row236.createCell(1);
        cell1.setCellValue("30%");

        final Row row237 = sheet1.createRow(237);
        cell1 = row237.createCell(0);
        cell1.setCellValue("B.SCOLIOSIS");

        final Row row238 = sheet1.createRow(238);
        cell1 = row238.createCell(0);
        cell1.setCellValue("Cobb's Angle 10 - 20°");
        cell1 = row238.createCell(1);
        cell1.setCellValue("1 - 5%");

        final Row row239 = sheet1.createRow(239);
        cell1 = row239.createCell(0);
        cell1.setCellValue("Cobb's Angle 21 - 30°");
        cell1 = row239.createCell(1);
        cell1.setCellValue("6 - 9%");

        final Row row240 = sheet1.createRow(240);
        cell1 = row240.createCell(0);
        cell1.setCellValue("Cobb's Angle 31 - 50°");
        cell1 = row240.createCell(1);
        cell1.setCellValue("10 - 19%");

        final Row row241 = sheet1.createRow(241);
        cell1 = row241.createCell(0);
        cell1.setCellValue("Cobb's Angle 51 - 75°");
        cell1 = row241.createCell(1);
        cell1.setCellValue("20 - 29%");
        cell1 = row241.createCell(4);
        cell1.setCellValue(finalDto.getClass_spinal_affection().getC_scoliosis_component().getScoliosis_inner().getScoliosisValue());

        final Row row242 = sheet1.createRow(242);
        cell1 = row242.createCell(0);
        cell1.setCellValue("Cobb's Angle 76 - 100°");
        cell1 = row242.createCell(1);
        cell1.setCellValue("30 - 39%");

        final Row row243 = sheet1.createRow(243);
        cell1 = row243.createCell(0);
        cell1.setCellValue("Cobb's Angle 101 - 125°");
        cell1 = row243.createCell(1);
        cell1.setCellValue("40 - 60%");

        final Row row244 = sheet1.createRow(244);
        cell1 = row244.createCell(0);
        cell1.setCellValue("Cobb's Angle 126° or more");
        cell1 = row244.createCell(1);
        cell1.setCellValue("more than 60%");

        final Row row245 = sheet1.createRow(245);
        cell1 = row245.createCell(0);
        cell1.setCellValue("Extra points for Scoliosis");

        final Row row246 = sheet1.createRow(246);
        cell1 = row246.createCell(0);
        cell1.setCellValue("A. Max. Chest Expansion     or");
        cell1 = row246.createCell(1);
        cell1.setCellValue("B. Single Breath Count");

        final Row row247 = sheet1.createRow(247);
        cell1 = row247.createCell(0);
        cell1.setCellValue("More than 4 cm - NIL");
        cell1 = row247.createCell(1);
        cell1.setCellValue("31 to 40 - 5%");

        final Row row248 = sheet1.createRow(248);
        cell1 = row248.createCell(0);
        cell1.setCellValue("2 to less than 3 cm - 10%");
        cell1 = row248.createCell(1);
        cell1.setCellValue("21 to 30 - 10%");
        cell1 = row248.createCell(4);
        cell1.setCellValue(finalDto.getClass_spinal_affection().getC_scoliosis_component().getSc_extra_points().getExtra_points());


        final Row row249 = sheet1.createRow(249);
        cell1 = row249.createCell(0);
        cell1.setCellValue("1 to less than 2 cm - 15%");
        cell1 = row249.createCell(1);
        cell1.setCellValue("11 to 20 - 15%");

        final Row row250 = sheet1.createRow(250);
        cell1 = row250.createCell(0);
        cell1.setCellValue("Less than 1 cm - 20%");
        cell1 = row250.createCell(1);
        cell1.setCellValue("5 to 10 - 20%");

        final Row row251 = sheet1.createRow(251);
        cell1 = row251.createCell(1);
        cell1.setCellValue("Less than 5 - 25%");

        final Row row252 = sheet1.createRow(252);
        cell1 = row252.createCell(0);
        cell1.setCellValue("More Extra points for Scoliosis");


        final Row row253 = sheet1.createRow(253);
        cell1 = row253.createCell(0);
        cell1.setCellValue("Torso Imbalance");

        final Row row254 = sheet1.createRow(254);
        cell1 = row254.createCell(0);
        cell1.setCellValue("Deviation of plumbline");

        final Row row256 = sheet1.createRow(256);
        cell1 = row256.createCell(0);
        cell1.setCellValue("upto 1.5 cm");
        cell1 = row256.createCell(1);
        cell1.setCellValue("4%");

        final Row row257 = sheet1.createRow(257);
        cell1 = row257.createCell(0);
        cell1.setCellValue("1.6 to 3.0 cm");
        cell1 = row257.createCell(1);
        cell1.setCellValue("8%");

        final Row row258 = sheet1.createRow(258);
        cell1 = row258.createCell(0);
        cell1.setCellValue("3.1 to 5.0 cm");
        cell1 = row258.createCell(1);
        cell1.setCellValue("16%");

        final Row row259 = sheet1.createRow(259);
        cell1 = row259.createCell(0);
        cell1.setCellValue("5.1 cm and above");
        cell1 = row259.createCell(1);
        cell1.setCellValue("32%");
        cell1 = row259.createCell(4);
        cell1.setCellValue(finalDto.getClass_spinal_affection().getC_scoliosis_component().getSc_more_extra_points().getTorsoImbalance());


        final Row row260 = sheet1.createRow(260);
        cell1 = row260.createCell(0);
        cell1.setCellValue("Head tilt over C7 spine");

        final Row row261 = sheet1.createRow(261);
        cell1 = row261.createCell(0);
        cell1.setCellValue("upto 15°");
        cell1 = row261.createCell(1);
        cell1.setCellValue("4%");

        final Row row262 = sheet1.createRow(262);
        cell1 = row262.createCell(0);
        cell1.setCellValue("more than 15°");
        cell1 = row262.createCell(1);
        cell1.setCellValue("10%");

        final Row row263 = sheet1.createRow(263);
        cell1 = row263.createCell(0);
        cell1.setCellValue("Associated Problems of Scoliosis");

        final Row row264 = sheet1.createRow(264);
        cell1 = row264.createCell(0);
        cell1.setCellValue("Pain");

        final Row row265 = sheet1.createRow(265);
        cell1 = row265.createCell(0);
        cell1.setCellValue("mildly interfering with ADL");
        cell1 = row265.createCell(1);
        cell1.setCellValue("4%");

        final Row row266 = sheet1.createRow(266);
        cell1 = row266.createCell(0);
        cell1.setCellValue("moderately restricting ADL");
        cell1 = row266.createCell(1);
        cell1.setCellValue("6%");

        final Row row267 = sheet1.createRow(267);
        cell1 = row267.createCell(0);
        cell1.setCellValue("severely restricting ADL");
        cell1 = row267.createCell(1);
        cell1.setCellValue("10%");

        final Row row268 = sheet1.createRow(268);
        cell1 = row268.createCell(0);
        cell1.setCellValue("Cosmesis");
        cell1 = row268.createCell(1);
        cell1.setCellValue("");
        cell1 = row268.createCell(4);
        cell1.setCellValue(finalDto.getClass_spinal_affection().getC_scoliosis_component().getSc_more_extra_points().getPain());


        final Row row269 = sheet1.createRow(269);
        cell1 = row269.createCell(0);
        cell1.setCellValue("no disfigurement with clothes on");
        cell1 = row269.createCell(1);
        cell1.setCellValue("NIL");

        final Row row270 = sheet1.createRow(270);
        cell1 = row270.createCell(0);
        cell1.setCellValue("mild disfigurement");
        cell1 = row270.createCell(1);
        cell1.setCellValue("2%");

        final Row row271 = sheet1.createRow(271);
        cell1 = row271.createCell(0);
        cell1.setCellValue("severe disfigurement");
        cell1 = row271.createCell(1);
        cell1.setCellValue("4%");

        final Row row272 = sheet1.createRow(272);
        cell1 = row272.createCell(0);
        cell1.setCellValue("Leg length discrepancy");

        final Row row273 = sheet1.createRow(273);
        cell1 = row273.createCell(0);
        cell1.setCellValue("first half inch shortening");
        cell1 = row273.createCell(1);
        cell1.setCellValue("NIL");

        final Row row274 = sheet1.createRow(274);
        cell1 = row274.createCell(0);
        cell1.setCellValue("every half inch thereafter");
        cell1 = row274.createCell(1);
        cell1.setCellValue("4%");

        final Row row275 = sheet1.createRow(275);
        cell1 = row275.createCell(0);
        cell1.setCellValue("SUBTOTAL FOR SCOLIOSIS");
        cell1 = row275.createCell(1);
        cell1.setCellValue("");
        cell1 = row275.createCell(4);
        cell1.setCellValue(finalDto.getClass_spinal_affection().getC_scoliosis_component().getSubTotalScoliosis());


        final Row row276 = sheet1.createRow(276);
        cell1 = row276.createCell(0);
        cell1.setCellValue("TOTAL FOR SCOLIOSIS");
        cell1 = row276.createCell(1);
        cell1.setCellValue("");
        cell1 = row276.createCell(4);
        cell1.setCellValue(finalDto.getClass_spinal_affection().getC_scoliosis_component().getTotalScoliosis());

        final Row row277 = sheet1.createRow(277);
        cell1 = row277.createCell(0);
        cell1.setCellValue("C.KYPHOSIS");

        final Row row278 = sheet1.createRow(278);
        cell1 = row278.createCell(0);
        cell1.setCellValue("Less than 40°");
        cell1 = row278.createCell(1);
        cell1.setCellValue("NIL");

        final Row row279 = sheet1.createRow(279);
        cell1 = row279.createCell(0);
        cell1.setCellValue("41-50°");
        cell1 = row279.createCell(1);
        cell1.setCellValue("10%");

        final Row row280 = sheet1.createRow(280);
        cell1 = row280.createCell(0);
        cell1.setCellValue("51-60°");
        cell1 = row280.createCell(1);
        cell1.setCellValue("20%");

        final Row row281 = sheet1.createRow(281);
        cell1 = row281.createCell(0);
        cell1.setCellValue("61-70°");
        cell1 = row281.createCell(1);
        cell1.setCellValue("30%");
        cell1 = row281.createCell(4);
        cell1.setCellValue(finalDto.getClass_spinal_affection().getC_kyphosis().getKyphosisValue());


        final Row row282 = sheet1.createRow(282);
        cell1 = row282.createCell(0);
        cell1.setCellValue("71-80°");
        cell1 = row282.createCell(1);
        cell1.setCellValue("40%");

        final Row row283 = sheet1.createRow(283);
        cell1 = row283.createCell(0);
        cell1.setCellValue("81-90°");
        cell1 = row283.createCell(1);
        cell1.setCellValue("50%");


        final Row row284 = sheet1.createRow(284);
        cell1 = row284.createCell(0);
        cell1.setCellValue("91-100°");
        cell1 = row284.createCell(1);
        cell1.setCellValue("60%");

        final Row row286 = sheet1.createRow(286);
        cell1 = row286.createCell(0);
        cell1.setCellValue("Torso Imbalance");

        final Row row287 = sheet1.createRow(287);
        cell1 = row287.createCell(0);
        cell1.setCellValue("Deviation of plumbline");

        final Row row288 = sheet1.createRow(288);
        cell1 = row288.createCell(0);
        cell1.setCellValue("Less than 5 cm in front of ankle");
        cell1 = row288.createCell(1);
        cell1.setCellValue("4%");

        final Row row289 = sheet1.createRow(289);
        cell1 = row289.createCell(0);
        cell1.setCellValue("5 to 10 cm in front of ankle");
        cell1 = row289.createCell(1);
        cell1.setCellValue("8%");

        final Row row290 = sheet1.createRow(290);
        cell1 = row290.createCell(0);
        cell1.setCellValue("10 to 15 cm in front of ankle");
        cell1 = row290.createCell(1);
        cell1.setCellValue("16%");
        cell1 = row290.createCell(4);
        cell1.setCellValue(finalDto.getClass_spinal_affection().getC_kyphosis().getTorsoImbalance());


        final Row row291 = sheet1.createRow(291);
        cell1 = row291.createCell(0);
        cell1.setCellValue("more than 15 cm in front of ankle");
        cell1 = row291.createCell(1);
        cell1.setCellValue("32%");

        final Row row292 = sheet1.createRow(292);
        cell1 = row292.createCell(0);
        cell1.setCellValue("TOTAL FOR KYPHOSIS");
        cell1 = row292.createCell(1);
        cell1.setCellValue("");
        cell1 = row292.createCell(4);
        cell1.setCellValue(finalDto.getClass_spinal_affection().getC_kyphosis().getInnerCalculations());


        final Row row293 = sheet1.createRow(293);
        cell1 = row293.createCell(0);
        cell1.setCellValue("D.MISC. MEDICAL CONDITIONS");


        final Row row294 = sheet1.createRow(294);
        cell1 = row294.createCell(0);
        cell1.setCellValue("pain");
        cell1 = row294.createCell(1);
        cell1.setCellValue("NIL");

        final Row row295 = sheet1.createRow(295);
        cell1 = row295.createCell(0);
        cell1.setCellValue("pain, spasm, stiffness, mild radiological changes");
        cell1 = row295.createCell(1);
        cell1.setCellValue("20%");

        final Row row296 = sheet1.createRow(296);
        cell1 = row296.createCell(0);
        cell1.setCellValue("pain, spasm, stiffness, moderate radiological changes");
        cell1 = row296.createCell(1);
        cell1.setCellValue("25%");
        cell1 = row296.createCell(4);
        cell1.setCellValue(finalDto.getClass_spinal_affection().getC_spin_affn_misc_med_conditions().getMedicalConditions());


        final Row row297 = sheet1.createRow(297);
        cell1 = row297.createCell(0);
        cell1.setCellValue("pain, spasm, stiffness, severe radiological changes");
        cell1 = row297.createCell(1);
        cell1.setCellValue("30%");

        final Row row298 = sheet1.createRow(298);
        cell1 = row298.createCell(0);
        cell1.setCellValue("pain, spasm, stiffness, severe radiological changes in whole spine");
        cell1 = row298.createCell(1);
        cell1.setCellValue("40%");

        final Row row299 = sheet1.createRow(299);
        cell1 = row299.createCell(0);
        cell1.setCellValue("E.NEUROLOGICAL DEFICIT");

        final Row row300 = sheet1.createRow(300);
        cell1 = row300.createCell(0);
        cell1.setCellValue("Motor");

        final Row row301 = sheet1.createRow(301);
        cell1 = row301.createCell(0);
        cell1.setCellValue("Quadriplegia");
        cell1 = row301.createCell(1);
        cell1.setCellValue("90%");

        final Row row302 = sheet1.createRow(302);
        cell1 = row302.createCell(0);
        cell1.setCellValue("Paraplegia");
        cell1 = row302.createCell(1);
        cell1.setCellValue("75%");
        cell1 = row302.createCell(4);
        cell1.setCellValue(finalDto.getClass_spinal_affection().getC_neurological_deficit().getMotor());


        final Row row303 = sheet1.createRow(303);
        cell1 = row303.createCell(0);
        cell1.setCellValue("Cauda Equina Syndrome without B/B involvement");
        cell1 = row303.createCell(1);
        cell1.setCellValue("40%");

        final Row row304 = sheet1.createRow(304);
        cell1 = row304.createCell(0);
        cell1.setCellValue("Cauda Equina Syndrome with B/B involvement");
        cell1 = row304.createCell(1);
        cell1.setCellValue("60%");

        final Row row305 = sheet1.createRow(305);
        cell1 = row305.createCell(0);
        cell1.setCellValue("Sensory");

        final Row row306 = sheet1.createRow(306);
        cell1 = row306.createCell(0);
        cell1.setCellValue("Anaesthesia");
        cell1 = row306.createCell(1);
        cell1.setCellValue("10% for each limb");

        final Row row307 = sheet1.createRow(307);
        cell1 = row307.createCell(0);
        cell1.setCellValue("Hypoaesthesia");
        cell1 = row307.createCell(1);
        cell1.setCellValue("depending upon loss of sensation");


        final Row row308 = sheet1.createRow(308);
        cell1 = row308.createCell(0);
        cell1.setCellValue("Paraesthesia");
        cell1 = row308.createCell(1);
        cell1.setCellValue("upto 30% depending upon loss of sensation");
        cell1 = row308.createCell(4);
        cell1.setCellValue(finalDto.getClass_spinal_affection().getC_neurological_deficit().getSensory());


        final Row row309 = sheet1.createRow(309);
        cell1 = row309.createCell(0);
        cell1.setCellValue("Hand and Feet Sensory Loss");
        cell1 = row309.createCell(1);
        cell1.setCellValue("depending upon loss of sensation");

        final Row row310 = sheet1.createRow(310);
        cell1 = row310.createCell(0);
        cell1.setCellValue("Bladder");

        final Row row311 = sheet1.createRow(311);
        cell1 = row311.createCell(0);
        cell1.setCellValue("Mild (Hesitancy/Frequency)");
        cell1 = row311.createCell(1);
        cell1.setCellValue("25%");

        final Row row312 = sheet1.createRow(312);
        cell1 = row312.createCell(0);
        cell1.setCellValue("Moderate (Precipitancy)");
        cell1 = row312.createCell(1);
        cell1.setCellValue("50%");

        final Row row313 = sheet1.createRow(313);
        cell1 = row313.createCell(0);
        cell1.setCellValue("Severe (Recurrent Incontinence)");
        cell1 = row313.createCell(1);
        cell1.setCellValue("75%");
        cell1 = row313.createCell(4);
        cell1.setCellValue(finalDto.getClass_spinal_affection().getC_neurological_deficit().getBladdar());

        final Row row314 = sheet1.createRow(314);
        cell1 = row314.createCell(0);
        cell1.setCellValue("Very Severe (Retention / Total Incontinence)");
        cell1 = row314.createCell(1);
        cell1.setCellValue("100%");

        final Row row315 = sheet1.createRow(315);
        cell1 = row315.createCell(0);
        cell1.setCellValue("Ataxia");

        final Row row316 = sheet1.createRow(316);
        cell1 = row316.createCell(0);
        cell1.setCellValue("Mild");
        cell1 = row316.createCell(1);
        cell1.setCellValue("<40%");

        final Row row317 = sheet1.createRow(317);
        cell1 = row317.createCell(0);
        cell1.setCellValue("Moderate");
        cell1 = row317.createCell(1);
        cell1.setCellValue("40 to 60%");
        cell1 = row317.createCell(4);
        cell1.setCellValue(finalDto.getClass_spinal_affection().getC_neurological_deficit().getAtaxia());

        final Row row318 = sheet1.createRow(318);
        cell1 = row318.createCell(0);
        cell1.setCellValue("Severe");
        cell1 = row318.createCell(1);
        cell1.setCellValue(">60%");

        final Row row319 = sheet1.createRow(319);
        cell1 = row319.createCell(0);
        cell1.setCellValue("Total Neurological Deficit");
        cell1 = row319.createCell(1);
        cell1.setCellValue("");
        cell1 = row319.createCell(4);
        cell1.setCellValue(finalDto.getClass_spinal_affection().getC_neurological_deficit().getTotalNeuroDeficit());

        final Row row320 = sheet1.createRow(320);
        cell1 = row320.createCell(0);
        cell1.setCellValue("TOTAL SPINAL DISABILITY");
        cell1 = row320.createCell(1);
        cell1.setCellValue("");
        cell1 = row320.createCell(4);
        cell1.setCellValue(finalDto.getClass_spinal_affection().getTotalSpinalDisability());


        final Row row321 = sheet1.createRow(321);
        cell1 = row321.createCell(0);
        cell1.setCellValue("VII.CEREBRAL PALSY");


        final Row row322 = sheet1.createRow(322);
        cell1 = row322.createCell(0);
        cell1.setCellValue("GMFCS I");
        cell1 = row322.createCell(1);
        cell1.setCellValue("< 40 %");

        final Row row323 = sheet1.createRow(323);
        cell1 = row323.createCell(0);
        cell1.setCellValue("GMFCS II");
        cell1 = row323.createCell(1);
        cell1.setCellValue("40 - 50%");

        final Row row324 = sheet1.createRow(324);
        cell1 = row324.createCell(0);
        cell1.setCellValue("GMFCS III");
        cell1 = row324.createCell(1);
        cell1.setCellValue("51 - 60%");
        cell1 = row324.createCell(4);
        cell1.setCellValue(finalDto.getC_cerebral_palsy().getCerebralPalsyValue());


        final Row row325 = sheet1.createRow(325);
        cell1 = row325.createCell(0);
        cell1.setCellValue("GMFCS IV");
        cell1 = row325.createCell(1);
        cell1.setCellValue("61 - 79%");

        final Row row326 = sheet1.createRow(326);
        cell1 = row326.createCell(0);
        cell1.setCellValue("GMFCS V");
        cell1 = row326.createCell(1);
        cell1.setCellValue("> 80%");

        final Row row327 = sheet1.createRow(327);
        cell1 = row327.createCell(0);
        cell1.setCellValue("TOTAL");


        String wrtBody = "wrt";
        if (AdditionalInfo.activityFLow.size() > 1) {
            // withResp.setText("Whole Body");
            wrtBody = wrtBody + "Whole Body";
        } else {
            for (Object value : AdditionalInfo.activityFLow.keySet()) {
                // withResp.setText(value.toString());
                wrtBody = wrtBody + value.toString();
            }
        }

        //TOTAL DISABILITY
        final Row row328 = sheet1.createRow(328);
        cell1 = row328.createCell(0);
        cell1.setCellValue("TOTAL DISABILITY");
        cell1 = row328.createCell(5);
        cell1.setCellValue(finalDto.getTotalDisability());
        cell1 = row328.createCell(6);
        cell1.setCellValue(wrtBody);
        cell1 = row328.createCell(7);
        if (additionalInfoDTO.isDeformityTreatable()) {
            cell1.setCellValue("TEMP");
        } else {
            cell1.setCellValue("PERMANENT");
        }
        cell1 = row328.createCell(8);
        cell1.setCellValue("Revaluation " + additionalInfoDTO.getRevaluationRequired());


        sheet1.setColumnWidth(0, (20 * 500));
        sheet1.setColumnWidth(1, (20 * 500));
        sheet1.setColumnWidth(2, (15 * 500));
        sheet1.setColumnWidth(3, (15 * 500));
        sheet1.setColumnWidth(4, (15 * 500));
        sheet1.setColumnWidth(5, (15 * 500));
        sheet1.setColumnWidth(6, (15 * 500));
        sheet1.setColumnWidth(7, (15 * 500));
        sheet1.setColumnWidth(8, (15 * 500));
        sheet1.setColumnWidth(9, (15 * 500));
        sheet1.setColumnWidth(10, (15 * 500));
        wb.write(outputStream);
    }

}